Table.Checks Propiedad

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

Espacio de nombres:  Microsoft.SqlServer.Management.Smo
Ensamblado:  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Sintaxis

'Declaración
<SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.ZeroToAny,  _
    GetType(Check), SfcObjectFlags.Design)> _
Public ReadOnly Property Checks As CheckCollection 
    Get
'Uso
Dim instance As Table 
Dim value As CheckCollection 

value = instance.Checks

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

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

[<SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.ZeroToAny, 
    typeof(Check), SfcObjectFlags.Design)>]
member Checks : CheckCollection

function get Checks () : CheckCollection

Valor de la propiedad

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

Ejemplos

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

C#

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

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("AdventureWorks2012")

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

Vea también

Referencia

Table Clase

Espacio de nombres Microsoft.SqlServer.Management.Smo

Otros recursos

Tablas

CREATE TABLE (Transact-SQL)