capabilities

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

Overview

Name	capabilities
Type	Resource
Id	azure.sql.capabilities

Fields

The following fields are returned by SELECT queries:

list_by_location

Successfully retrieved the subscription location capabilities.

Name	Datatype	Description
name	string	The location name.
reason	string	The reason for the capability not being available.
status	string	The status of the capability.
supportedManagedInstanceVersions	array	The list of supported managed instance versions.
supportedServerVersions	array	The list of supported server versions.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list_by_location	select	locationName, subscriptionId	include	Gets the subscription capabilities available for the specified location.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
locationName	string	The location name whose capabilities are retrieved.
subscriptionId	string	The subscription ID that identifies an Azure subscription.
include	string	If specified, restricts the response to only include the selected item.

SELECT examples

list_by_location

Gets the subscription capabilities available for the specified location.

SELECT
name,
reason,
status,
supportedManagedInstanceVersions,
supportedServerVersions
FROM azure.sql.capabilities
WHERE locationName = '{{ locationName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
AND include = '{{ include }}'
;