capabilities

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

Overview

Name	capabilities
Type	Resource
Id	azure.sql.capabilities

Fields

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

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

SELECT examples

Gets the subscription capabilities available for the specified location.

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