發行項
04/02/2012

HasAfterTrigger 屬性

取得 Boolean 屬性值，指定資料表是否有任何 After 觸發程序。

命名空間： Microsoft.SqlServer.Management.Smo
組件： Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property HasAfterTrigger As Boolean
    Get
'用途
Dim instance As Table
Dim value As Boolean

value = instance.HasAfterTrigger

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public bool HasAfterTrigger { get; }

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
property bool HasAfterTrigger {
    bool get ();
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
member HasAfterTrigger : bool

function get HasAfterTrigger () : boolean

屬性值

型別：System. . :: . .Boolean
Boolean 值，這個值會指定資料表是否有定義任何 After 觸發程序。
如果為 True，則表示至少其中一個資料表的觸發程序定義為 After 觸發程序。
如果為 False (預設值)，則表示資料表沒有定義任何 After 觸發程序。

備註

An after trigger runs on successful completion of the triggering statement. All referential cascade actions and constraint checks also must succeed before this trigger executes.

範例

The following code example shows how to check each table in the AdventureWorks2008R2 database to see if it has any after triggers.

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

Foreach (Table tb in db.Tables) 
{
   Console.WriteLine("The " + tb.Name + " table has after triggers:" + tb.HasAfterTrigger.ToString());
}

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) 
{
   Write-Host "The" $tb.Name "table has after triggers:" $tb.HasAfterTrigger
}