Checks 屬性
命名空間: 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
表示資料表上所定義之所有檢查條件約束的 Check 物件。
範例
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."
}
}