Get-SqlInformation_Schema.Routines

Returns the result set from INFORMATION_SCHEMA.Routines for the specified database(s).

Syntax

Get-SqlInformation_Schema.Routines [-database] <Database> [[-name] <String>] [[-text] <String>] [<CommonParameters>]

Detailed Description

The Get-SqlInformation_Schema.Routines function returns the result set from Information_Schema.Routines for the specified database(s).

Related Commands

* Get-SqlInformation_Schema.Routines

Parameters

Name Description Required? Pipeline Input Default Value
database    true  true (ByValue)   
name    false  false   
text    false  false   

Input Type

Microsoft.SqlServer.Management.Smo.Database You can pipe Database objects to Get-SqlInformation_Schema.Routines

Return Values

System.Data.DataRow Get-SqlInformation_Schema.Routines returns an array of System.Data.DataRow.

Examples

EXAMPLE 1

Get-SqlDatabase "Z002\sql2k8" "pubs" | Get-Information_Schema.Routines
This command returns the result set from INFORMATION_SCHEMA.Routines for the pubs database.

EXAMPLE 2

Get-SqlDatabase "Z002\sql2k8" "pubs" | Get-Information_Schema.Routines -name "reptq1"
This command returns the result set from INFORMATION_SCHEMA.Routines for the pubs database where the routine name is like reptq1.