Get-SqlSysDatabases
Returns the result set from sysdatabases for the specified SQL server.
Syntax
Get-SqlSysDatabases [-sqlserver] <Object> [[-name] <String>] [<CommonParameters>]
Detailed Description
The Get-SqlSysDatabases function returns the result set from SysDatabases for the specified SQL server.
Related Commands
Parameters
Name |
Description |
Required? |
Pipeline Input |
Default Value |
sqlserver |
|
true |
false |
|
name |
|
false |
false |
|
Input Type
None
You cannot pipe objects to Get-SqlSysDatabases
Return Values
System.Data.DataRow
Get-SqlSysDatabases returns an array of System.Data.DataRow.
Examples
EXAMPLE 1
Get-SqlSysDatabases "Z002\sql2k8"
This command returns the result set from SysDatabases for the Z002\sql2k8 SQL server.
EXAMPLE 2
Get-SqlSysDatabases "Z002\sql2k8" -name "pubs"
This command returns the result set from SysDatabases where the database name is like pubs.