--- title: "GET /subscriptions/{subscriptionId}/providers/Microsoft.Sql/locations/{locationName}/capabilities" method: GET path: "/subscriptions/{subscriptionId}/providers/Microsoft.Sql/locations/{locationName}/capabilities" tags: ["LocationCapabilities"] --- # GET /subscriptions/{subscriptionId}/providers/Microsoft.Sql/locations/{locationName}/capabilities `GET /subscriptions/{subscriptionId}/providers/Microsoft.Sql/locations/{locationName}/capabilities` Gets the subscription capabilities available for the specified location. ## Path parameters - `locationName` string, required - `subscriptionId` string, required ## Query parameters - `include` 'supportedEditions' | 'supportedElasticPoolEditions' | 'supportedManagedInstanceVersions' - `api-version` string, required ## Response `200` Successfully retrieved the subscription location capabilities. - LocationCapabilities — The location capability. - `name` string — The location name. - `supportedServerVersions` ServerVersionCapability[] — The list of supported server versions. - `name` string — The server version name. - `supportedEditions` EditionCapability[] — The list of supported database editions. - `name` string — The database edition name. - `supportedServiceLevelObjectives` ServiceObjectiveCapability[] — The list of supported service objectives for the edition. - `id` string, uuid — The unique ID of the service objective. - `name` string — The service objective name. - `supportedMaxSizes` MaxSizeRangeCapability[] — The list of supported maximum database sizes. - `minValue` MaxSizeCapability — The maximum size capability. - `limit` integer — The maximum size limit (see 'unit' for the units). - `unit` 'Megabytes' | 'Gigabytes' | 'Terabytes' | 'Petabytes' — The units that the limit is expressed in. - `maxValue` MaxSizeCapability — The maximum size capability. - `limit` integer — The maximum size limit (see 'unit' for the units). - `unit` 'Megabytes' | 'Gigabytes' | 'Terabytes' | 'Petabytes' — The units that the limit is expressed in. - `scaleSize` MaxSizeCapability — The maximum size capability. - `limit` integer — The maximum size limit (see 'unit' for the units). - `unit` 'Megabytes' | 'Gigabytes' | 'Terabytes' | 'Petabytes' — The units that the limit is expressed in. - `logSize` LogSizeCapability — The log size capability. - `limit` integer — The log size limit (see 'unit' for the units). - `unit` 'Megabytes' | 'Gigabytes' | 'Terabytes' | 'Petabytes' | 'Percent' — The units that the limit is expressed in. - `status` 'Visible' | 'Available' | 'Default' | 'Disabled' — The status of the capability. - `reason` string — The reason for the capability not being available. - `performanceLevel` PerformanceLevelCapability — The performance level capability. - `value` number, double — Performance level value. - `unit` 'DTU' | 'VCores' — Unit type used to measure performance level. - `sku` Sku — unresolved $ref - `supportedLicenseTypes` LicenseTypeCapability[] — List of supported license types. - `name` string — License type identifier. - `status` 'Visible' | 'Available' | 'Default' | 'Disabled' — The status of the capability. - `reason` string — The reason for the capability not being available. - `includedMaxSize` MaxSizeCapability — The maximum size capability. - `limit` integer — The maximum size limit (see 'unit' for the units). - `unit` 'Megabytes' | 'Gigabytes' | 'Terabytes' | 'Petabytes' — The units that the limit is expressed in. - `status` 'Visible' | 'Available' | 'Default' | 'Disabled' — The status of the capability. - `reason` string — The reason for the capability not being available. - `zoneRedundant` boolean — Whether or not zone redundancy is supported for the edition. - `status` 'Visible' | 'Available' | 'Default' | 'Disabled' — The status of the capability. - `reason` string — The reason for the capability not being available. - `supportedElasticPoolEditions` ElasticPoolEditionCapability[] — The list of supported elastic pool editions. - `name` string — The elastic pool edition name. - `supportedElasticPoolPerformanceLevels` ElasticPoolPerformanceLevelCapability[] — The list of supported elastic pool DTU levels for the edition. - `performanceLevel` PerformanceLevelCapability — The performance level capability. - `value` number, double — Performance level value. - `unit` 'DTU' | 'VCores' — Unit type used to measure performance level. - `sku` Sku — unresolved $ref - `supportedLicenseTypes` LicenseTypeCapability[] — List of supported license types. - `name` string — License type identifier. - `status` 'Visible' | 'Available' | 'Default' | 'Disabled' — The status of the capability. - `reason` string — The reason for the capability not being available. - `maxDatabaseCount` integer — The maximum number of databases supported. - `includedMaxSize` MaxSizeCapability — The maximum size capability. - `limit` integer — The maximum size limit (see 'unit' for the units). - `unit` 'Megabytes' | 'Gigabytes' | 'Terabytes' | 'Petabytes' — The units that the limit is expressed in. - `supportedMaxSizes` MaxSizeRangeCapability[] — The list of supported max sizes. - `minValue` MaxSizeCapability — The maximum size capability. - `limit` integer — The maximum size limit (see 'unit' for the units). - `unit` 'Megabytes' | 'Gigabytes' | 'Terabytes' | 'Petabytes' — The units that the limit is expressed in. - `maxValue` MaxSizeCapability — The maximum size capability. - `limit` integer — The maximum size limit (see 'unit' for the units). - `unit` 'Megabytes' | 'Gigabytes' | 'Terabytes' | 'Petabytes' — The units that the limit is expressed in. - `scaleSize` MaxSizeCapability — The maximum size capability. - `limit` integer — The maximum size limit (see 'unit' for the units). - `unit` 'Megabytes' | 'Gigabytes' | 'Terabytes' | 'Petabytes' — The units that the limit is expressed in. - `logSize` LogSizeCapability — The log size capability. - `limit` integer — The log size limit (see 'unit' for the units). - `unit` 'Megabytes' | 'Gigabytes' | 'Terabytes' | 'Petabytes' | 'Percent' — The units that the limit is expressed in. - `status` 'Visible' | 'Available' | 'Default' | 'Disabled' — The status of the capability. - `reason` string — The reason for the capability not being available. - `supportedPerDatabaseMaxSizes` MaxSizeRangeCapability[] — The list of supported per database max sizes. - `minValue` MaxSizeCapability — The maximum size capability. - `limit` integer — The maximum size limit (see 'unit' for the units). - `unit` 'Megabytes' | 'Gigabytes' | 'Terabytes' | 'Petabytes' — The units that the limit is expressed in. - `maxValue` MaxSizeCapability — The maximum size capability. - `limit` integer — The maximum size limit (see 'unit' for the units). - `unit` 'Megabytes' | 'Gigabytes' | 'Terabytes' | 'Petabytes' — The units that the limit is expressed in. - `scaleSize` MaxSizeCapability — The maximum size capability. - `limit` integer — The maximum size limit (see 'unit' for the units). - `unit` 'Megabytes' | 'Gigabytes' | 'Terabytes' | 'Petabytes' — The units that the limit is expressed in. - `logSize` LogSizeCapability — The log size capability. - `limit` integer — The log size limit (see 'unit' for the units). - `unit` 'Megabytes' | 'Gigabytes' | 'Terabytes' | 'Petabytes' | 'Percent' — The units that the limit is expressed in. - `status` 'Visible' | 'Available' | 'Default' | 'Disabled' — The status of the capability. - `reason` string — The reason for the capability not being available. - `supportedPerDatabaseMaxPerformanceLevels` ElasticPoolPerDatabaseMaxPerformanceLevelCapability[] — The list of supported per database max performance levels. - `limit` number, double — The maximum performance level per database. - `unit` 'DTU' | 'VCores' — Unit type used to measure performance level. - `supportedPerDatabaseMinPerformanceLevels` ElasticPoolPerDatabaseMinPerformanceLevelCapability[] — The list of supported min database performance levels. - `limit` number, double — The minimum performance level per database. - `unit` 'DTU' | 'VCores' — Unit type used to measure performance level. - `status` 'Visible' | 'Available' | 'Default' | 'Disabled' — The status of the capability. - `reason` string — The reason for the capability not being available. - `status` 'Visible' | 'Available' | 'Default' | 'Disabled' — The status of the capability. - `reason` string — The reason for the capability not being available. - `status` 'Visible' | 'Available' | 'Default' | 'Disabled' — The status of the capability. - `reason` string — The reason for the capability not being available. - `zoneRedundant` boolean — Whether or not zone redundancy is supported for the edition. - `status` 'Visible' | 'Available' | 'Default' | 'Disabled' — The status of the capability. - `reason` string — The reason for the capability not being available. - `status` 'Visible' | 'Available' | 'Default' | 'Disabled' — The status of the capability. - `reason` string — The reason for the capability not being available. - `supportedManagedInstanceVersions` ManagedInstanceVersionCapability[] — The list of supported managed instance versions. - `name` string — The server version name. - `supportedEditions` ManagedInstanceEditionCapability[] — The list of supported managed instance editions. - `name` string — The managed server version name. - `supportedFamilies` ManagedInstanceFamilyCapability[] — The supported families. - `name` string — Family name. - `sku` string — SKU name. - `supportedLicenseTypes` LicenseTypeCapability[] — List of supported license types. - `name` string — License type identifier. - `status` 'Visible' | 'Available' | 'Default' | 'Disabled' — The status of the capability. - `reason` string — The reason for the capability not being available. - `supportedVcoresValues` ManagedInstanceVcoresCapability[] — List of supported virtual cores values. - `name` string — The virtual cores identifier. - `value` integer — The virtual cores value. - `status` 'Visible' | 'Available' | 'Default' | 'Disabled' — The status of the capability. - `reason` string — The reason for the capability not being available. - `includedMaxSize` MaxSizeCapability — The maximum size capability. - `limit` integer — The maximum size limit (see 'unit' for the units). - `unit` 'Megabytes' | 'Gigabytes' | 'Terabytes' | 'Petabytes' — The units that the limit is expressed in. - `supportedStorageSizes` MaxSizeRangeCapability[] — Storage size ranges. - `minValue` MaxSizeCapability — The maximum size capability. - `limit` integer — The maximum size limit (see 'unit' for the units). - `unit` 'Megabytes' | 'Gigabytes' | 'Terabytes' | 'Petabytes' — The units that the limit is expressed in. - `maxValue` MaxSizeCapability — The maximum size capability. - `limit` integer — The maximum size limit (see 'unit' for the units). - `unit` 'Megabytes' | 'Gigabytes' | 'Terabytes' | 'Petabytes' — The units that the limit is expressed in. - `scaleSize` MaxSizeCapability — The maximum size capability. - `limit` integer — The maximum size limit (see 'unit' for the units). - `unit` 'Megabytes' | 'Gigabytes' | 'Terabytes' | 'Petabytes' — The units that the limit is expressed in. - `logSize` LogSizeCapability — The log size capability. - `limit` integer — The log size limit (see 'unit' for the units). - `unit` 'Megabytes' | 'Gigabytes' | 'Terabytes' | 'Petabytes' | 'Percent' — The units that the limit is expressed in. - `status` 'Visible' | 'Available' | 'Default' | 'Disabled' — The status of the capability. - `reason` string — The reason for the capability not being available. - `status` 'Visible' | 'Available' | 'Default' | 'Disabled' — The status of the capability. - `reason` string — The reason for the capability not being available. - `status` 'Visible' | 'Available' | 'Default' | 'Disabled' — The status of the capability. - `reason` string — The reason for the capability not being available. - `status` 'Visible' | 'Available' | 'Default' | 'Disabled' — The status of the capability. - `reason` string — The reason for the capability not being available. - `status` 'Visible' | 'Available' | 'Default' | 'Disabled' — The status of the capability. - `reason` string — The reason for the capability not being available. ## Other responses - `default` — *** Error Responses: *** * 400 SubscriptionNotFound - The requested subscription was not found. * 400 InvalidLocation - An invalid location was specified. --- [API](https://skmtc.dev/azure/apis/sqlmanagementclient-26.md) · [All operations](https://skmtc.dev/azure/apis/sqlmanagementclient-26/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/azure/sqlmanagementclient-26/revisions/1c12257eb0ed/schema)