Get-SqlCheck

Gets an SMO Check object.

Syntax

Get-SqlCheck [-table] <Object> [<CommonParameters>]

Detailed Description

The Get-SqlCheck function gets a collection of SMO Check objects for the specified table or view.

Related Commands

* Get-SqlCheck

Parameters

Name Description Required? Pipeline Input Default Value
table    true  true (ByValue)   

Input Type

Microsoft.SqlServer.Management.Smo.Table or Microsoft.SqlServer.Management.Smo.View You can pipe SMO objects to Get-SqlCheck

Return Values

Microsoft.SqlServer.Management.Smo.Check Get-SqlCheck returns a Microsoft.SqlServer.Management.Smo.Check object.

Notes

Additional properties including the database, server and extended properties are included in the output.

Examples

EXAMPLE 1

Get-SqlDatabase "Z002\sql2k8" "pubs" | Get-SqlTable | Get-SqlCheck
This command gets a collection of SMO Check objects for all user tables in the pubs database.