Propriété Checks
Représente une collection d'objets Check. Chaque objet Check représente une contrainte de validation définie sur la table.
Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Syntaxe
'Déclaration
<SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.ZeroToAny, _
GetType(Check), SfcObjectFlags.Design)> _
Public ReadOnly Property Checks As CheckCollection
Get
'Utilisation
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
Valeur de propriété
Type : Microsoft.SqlServer.Management.Smo. . :: . .CheckCollection
Objet Check qui représente toutes les contraintes de validation définies sur la table.
Exemples
The following code example shows how to display the names of each check constraint on each AdventureWorks2008R2 table.
C#
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."
}
}
Voir aussi