location_based_capability_sets

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

Overview

Name	location_based_capability_sets
Type	Resource
Id	azure.mysql.location_based_capability_sets

Fields

vw_location_based_capability_sets

Name	Datatype	Description
capabilitySetName	text	field from the properties object
locationName	text	field from the properties object
subscriptionId	text	field from the properties object
supported_flexible_server_editions	text	field from the properties object
supported_geo_backup_regions	text	field from the properties object
supported_server_versions	text	field from the properties object

location_based_capability_sets

Name	Datatype	Description
properties	object	Location capability.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	capabilitySetName, locationName, subscriptionId	Get capabilities at specified location in a given subscription.
list	SELECT	locationName, subscriptionId	Get capabilities at specified location in a given subscription.

SELECT examples

Get capabilities at specified location in a given subscription.

vw_location_based_capability_sets

SELECT
capabilitySetName,
locationName,
subscriptionId,
supported_flexible_server_editions,
supported_geo_backup_regions,
supported_server_versions
FROM azure.mysql.vw_location_based_capability_sets
WHERE locationName = '{{ locationName }}'
AND subscriptionId = '{{ subscriptionId }}';

location_based_capability_sets

SELECT
properties
FROM azure.mysql.location_based_capability_sets
WHERE locationName = '{{ locationName }}'
AND subscriptionId = '{{ subscriptionId }}';