Get-SqlInformation_Schema.Views
Returns the result set from INFORMATION_SCHEMA.Views for the specified database(s).
Syntax
Get-SqlInformation_Schema.Views [-database] <Database> [[-name] <String>] [<CommonParameters>]
Detailed Description
The Get-SqlInformation_Schema.Views function returns the result set from Information_Schema.Views for the specified database(s).
Related Commands
Parameters
Name |
Description |
Required? |
Pipeline Input |
Default Value |
database |
|
true |
true (ByValue) |
|
name |
|
false |
false |
|
Input Type
Microsoft.SqlServer.Management.Smo.Database
You can pipe Database objects to Get-SqlInformation_Schema.Views
Return Values
System.Data.DataRow
Get-SqlInformation_Schema.Views returns an array of System.Data.DataRow.
Examples
EXAMPLE 1
Get-SqlDatabase "Z002\sql2k8" "pubs" | Get-Information_Schema.Views
This command returns the result set from INFORMATION_SCHEMA.Views for the pubs database.
EXAMPLE 2
Get-SqlDatabase "Z002\sql2k8" "pubs" | Get-Information_Schema.Views -name "titleview"
This command returns the result set from INFORMATION_SCHEMA.Views for the pubs database where the view name is like titleview.