service_objectives

Creates, updates, deletes, gets or lists a service_objectives resource.

Overview

Name	service_objectives
Type	Resource
Id	azure.sql.service_objectives

Fields

vw_service_objectives

Name	Datatype	Description
description	text	field from the properties object
enabled	text	field from the properties object
is_default	text	field from the properties object
is_system	text	field from the properties object
resourceGroupName	text	field from the properties object
serverName	text	field from the properties object
serviceObjectiveName	text	field from the properties object
service_objective_name	text	field from the properties object
subscriptionId	text	field from the properties object

service_objectives

Name	Datatype	Description
properties	object	Represents the properties of a database service objective.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, serverName, serviceObjectiveName, subscriptionId	Gets a database service objective.
list_by_server	SELECT	resourceGroupName, serverName, subscriptionId	Returns database service objectives.

SELECT examples

Returns database service objectives.

vw_service_objectives

SELECT
description,
enabled,
is_default,
is_system,
resourceGroupName,
serverName,
serviceObjectiveName,
service_objective_name,
subscriptionId
FROM azure.sql.vw_service_objectives
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

service_objectives

SELECT
properties
FROM azure.sql.service_objectives
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';