Get-AzSqlCapability

Reference

Module:: Az.Sql

Gets SQL Database capabilities for the current subscription.

Syntax

Get-AzSqlCapability
   [-LocationName] <String>
   [-ServerVersionName <String>]
   [-EditionName <String>]
   [-ServiceObjectiveName <String>]
   [-DefaultProfile <IAzureContextContainer>]
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]

Get-AzSqlCapability
   [-LocationName] <String>
   [-Defaults]
   [-DefaultProfile <IAzureContextContainer>]
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]

Description

The Get-AzSqlCapability cmdlet gets the Azure SQL Database capabilities available on the current subscription for a region. If you specify the ServerVersionName, EditionName, or ServiceObjectiveName parameters, this cmdlet returns the specified values and their predecessors.

Examples

Example 1: Get capabilities for the current subscription for a region

Get-AzSqlCapability -LocationName "Central US"

Location                : Central US
Status                  : Available
SupportedServerVersions : {12.0, 2.0}

This command returns the capabilities for SQL Database instances on the current subscription for the Central US region.

Example 2: Get default capabilities for the current subscription for a region

Get-AzSqlCapability -LocationName "Central US" -Defaults

Location        : Central US
Status          : Available
ExpandedDetails : Version: 2.0 (Default) -> Edition: Standard (Default) -> Service Objective: S0 (Default)

This command returns the default capabilities for SQL Databases on the current subscription in the Central US region.

Example 3: Get details for a service objective

Get-AzSqlCapability -LocationName "Central US" -ServiceObjectiveName "S1"

Location        : Central US
Status          : Available
ExpandedDetails : Version: 12.0 (Available) -> Edition: Standard (Default) -> Service Objective: S1 (Available) 
                  Version: 2.0 (Default) -> Edition: Standard (Default) -> Service Objective: S1 (Available)

This command gets default capabilities for SQL Databases for the specified service objective on the current subscription.

Parameters

-Confirm

Prompts you for confirmation before running the cmdlet.

Type:	SwitchParameter
Aliases:	cf
Position:	Named
Default value:	False
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-DefaultProfile

The credentials, account, tenant, and subscription used for communication with azure

Type:	IAzureContextContainer
Aliases:	AzContext, AzureRmContext, AzureCredential
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Defaults

Indicates that this cmdlet gets only defaults.

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-EditionName

Specifies the name of the database edition for which this cmdlet gets capabilities.

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	True
Accept wildcard characters:	False

-LocationName

Specifies the name of the Location for which this cmdlet gets capabilities. For more information, see Azure Regionshttp://azure.microsoft.com/en-us/regions/ (http://azure.microsoft.com/en-us/regions/).

Type:	String
Position:	0
Default value:	None
Required:	True
Accept pipeline input:	True
Accept wildcard characters:	False

-ServerVersionName

Specifies the name of the server version for which this cmdlet gets capabilities.

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	True
Accept wildcard characters:	False

-ServiceObjectiveName

Specifies the name of the service objective for which this cmdlet gets capabilities.

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	True
Accept wildcard characters:	False

-WhatIf

Shows what would happen if the cmdlet runs. The cmdlet is not run.

Type:	SwitchParameter
Aliases:	wi
Position:	Named
Default value:	False
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

Inputs

String

Outputs

LocationCapabilityModel