This topic has not yet been rated - Rate this topic

Table.Checks Property

SQL Server 2008 R2

Represents a collection of Check objects. Each Check object represents a check constraint defined on the table.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

C++

JScript

[SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.ZeroToAny, 
	typeof(Check), SfcObjectFlags.Design)]
public CheckCollection Checks { get; }

Property Value

Type: Microsoft.SqlServer.Management.Smo.CheckCollection
A Check object that represents all the check constraints that are defined on the table.

Examples

The following code example shows how to display the names of each check constraint on each AdventureWorks2008R2 table.

Server srv = new Server("(local)");
Database db = srv.Databases["AdventureWorks2008R2"];

foreach (Table tb in db.Tables)
{
   foreach (Check ck in tb.Checks)
   {
      Console.WriteLine("The " + tb.Name + " table has the " + ck.ToString() + " check.");
   }
}

Powershell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2008R2")

Foreach ($tb in $db.Tables)
{
   Foreach ($ck in $tb.Checks)
   {
      Write-Host "The" $tb.Name "table has the" $ck "check."
   }
}

Reference

Table Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Tables

CREATE TABLE (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD