Table.Checks 属性
Represents a collection of Check objects. Each Check object represents a check constraint defined on the table.
命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)
语法
声明
<SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.ZeroToAny, _
GetType(Check), SfcObjectFlags.Design)> _
Public ReadOnly Property Checks As CheckCollection
Get
用法
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
属性值
类型:Microsoft.SqlServer.Management.Smo.CheckCollection
A Check object that represents all the check constraints that are defined on the table.
示例
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."
}
}
请参阅
参考
Microsoft.SqlServer.Management.Smo 命名空间