< Back
Get-DataSchema
Post
NAME Get-DataSchema
SYNOPSIS
Gets database schema information.
SYNTAX
Get-DataSchema [-FileOrName] <string> [[-CollectionName] <string>] [<CommonParameters>]
Get-DataSchema [-Connection] <DbConnection> [[-CollectionName] <string>] [<CommonParameters>]
DESCRIPTION
The Get-DataSchema cmdlet gets database schema information that the database engine provides. If a schema
collection name (-CollectionName) is not specified, it returns the information of all available schemas. The
provided information varies among database products.
PARAMETERS
-FileOrName <string>
A database file name or a connection string name.
Required? true
Position? 0
Default value
Accept pipeline input? false
Accept wildcard characters? false
-Connection <DbConnection>
A database connection.
Required? true
Position? 0
Default value
Accept pipeline input? false
Accept wildcard characters? false
-CollectionName <string>
A schama collection name.
Required? false
Position? 1
Default value
Accept pipeline input? false
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
OUTPUTS
System.Data.DataRow
RELATED LINKS
SYNOPSIS
Gets database schema information.
SYNTAX
Get-DataSchema [-FileOrName] <string> [[-CollectionName] <string>] [<CommonParameters>]
Get-DataSchema [-Connection] <DbConnection> [[-CollectionName] <string>] [<CommonParameters>]
DESCRIPTION
The Get-DataSchema cmdlet gets database schema information that the database engine provides. If a schema
collection name (-CollectionName) is not specified, it returns the information of all available schemas. The
provided information varies among database products.
PARAMETERS
-FileOrName <string>
A database file name or a connection string name.
Required? true
Position? 0
Default value
Accept pipeline input? false
Accept wildcard characters? false
-Connection <DbConnection>
A database connection.
Required? true
Position? 0
Default value
Accept pipeline input? false
Accept wildcard characters? false
-CollectionName <string>
A schama collection name.
Required? false
Position? 1
Default value
Accept pipeline input? false
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
OUTPUTS
System.Data.DataRow
RELATED LINKS