Get-AzureSqlElasticPoolDatabase
Get-AzureSqlElasticPoolDatabase
Gets elastic databases in an elastic pool and their property values.
Syntax
Parameter Set: Default
Get-AzureSqlElasticPoolDatabase [-ResourceGroupName] <System.String> [-ServerName] <System.String> [-ElasticPoolName] <System.String> [-DatabaseName <System.String> ] [-Profile <Microsoft.Azure.Common.Authentication.Models.AzureProfile> ]
Detailed Description
The Get-AzureSqlElasticPoolDatabase cmdlet gets elastic databases in an elastic pool and their property values. Specify the name of an elastic database in Azure SQL Database to see the property values for only that database.
Parameters
-DatabaseName<System.String>
Specifies the name of the Azure SQL Database that this cmdlet gets.
Aliases |
none |
Required? |
false |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
true(ByPropertyName) |
Accept Wildcard Characters? |
false |
-ElasticPoolName<System.String>
Specifies the name of an elastic pool. This cmdlet gets databases in the pool that this parameter specifies.
Aliases |
none |
Required? |
true |
Position? |
3 |
Default Value |
none |
Accept Pipeline Input? |
true(ByPropertyName) |
Accept Wildcard Characters? |
false |
-Profile<Microsoft.Azure.Common.Authentication.Models.AzureProfile>
Specifies the Azure profile from which this cmdlet reads. If you do not specify a profile, this cmdlet reads from the local default profile.
Aliases |
none |
Required? |
false |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-ResourceGroupName<System.String>
Specifies the name of a resource group that contains an elastic pool. This cmdlet gets a database in a pool in the resource group that this parameter specifies.
Aliases |
none |
Required? |
true |
Position? |
1 |
Default Value |
none |
Accept Pipeline Input? |
true(ByPropertyName) |
Accept Wildcard Characters? |
false |
-ServerName<System.String>
Specifies the name of a server that contains an elastic pool. This cmdlet gets a database in a pool on the server that this parameter specifies.
Aliases |
none |
Required? |
true |
Position? |
2 |
Default Value |
none |
Accept Pipeline Input? |
true(ByPropertyName) |
Accept Wildcard Characters? |
false |
Inputs
The input type is the type of the objects that you can pipe to the cmdlet.
InputType
System.String
Outputs
The output type is the type of the objects that the cmdlet emits.
OutputType
System.Object
Notes
- This cmdlet supports the common parameters: Verbose, Debug, ErrorAction, ErrorVariable, WarningAction, WarningVariable, OutBuffer, PipelineVariable, and OutVariable. For more information, see about_CommonParameters.
Examples
Example 1: Get all databases in an elastic pool
This command gets all databases in an elastic pool named ElasticPool27.
PS C:\> Get-AzureSqlElasticPoolDatabase -ResourceGroupName "ResourceGroup11" -ServerName "Server01" -ElasticPoolName "ElasticPool27"
Related topics
Get-AzureSqlElasticPoolActivity