Get-​Azure​Rm​Sql​Capability

Gets SQL Database capabilities for the current subscription.

Syntax

Get-AzureRmSqlCapability
   [-LocationName] <String>
   [-Defaults]
   [-Confirm]
   [-WhatIf]
   [<CommonParameters>]
Get-AzureRmSqlCapability
   [-LocationName] <String>
   [-EditionName <String>]
   [-ServerVersionName <String>]
   [-ServiceObjectiveName <String>]
   [-Confirm]
   [-WhatIf]
   [<CommonParameters>]

Description

The Get-AzureRmSqlCapability 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

PS C:\>Get-AzureRmSqlCapability -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

PS C:\>Get-AzureRmSqlCapability -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

PS C:\>Get-AzureRmSqlCapability -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.

Required Parameters

-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
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

Optional Parameters

-Confirm

Prompts you for confirmation before running the cmdlet.

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

Indicates that this cmdlet gets only defaults.

Type:SwitchParameter
Position:Named
Default value:None
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
Accept pipeline input:True (ByPropertyName)
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
Accept pipeline input:True (ByPropertyName)
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
Accept pipeline input:True (ByPropertyName)
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
Accept pipeline input:False
Accept wildcard characters:False

Outputs

Microsoft.Azure.Commands.Sql.Location_Capabilities.Model.LocationCapabilityModel