HasInsteadOfTrigger 屬性
取得 Boolean 屬性值,指定資料表是否有任何 Instead Of 觸發程序。
命名空間: Microsoft.SqlServer.Management.Smo
組件: Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)
語法
'宣告
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property HasInsteadOfTrigger As Boolean
Get
'用途
Dim instance As Table
Dim value As Boolean
value = instance.HasInsteadOfTrigger
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public bool HasInsteadOfTrigger { get; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
property bool HasInsteadOfTrigger {
bool get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
member HasInsteadOfTrigger : bool
function get HasInsteadOfTrigger () : boolean
屬性值
型別:System. . :: . .Boolean
Boolean 值,這個值會指定資料表是否有定義任何 instead of 觸發程序。
如果為 True,則表示至少其中一個資料表的觸發程序定義為 instead of 觸發程序,否則為 False (預設值)。
備註
An "instead of" trigger runs instead of the triggering statement.
範例
The following code example shows how to list each table in the AdventureWorks2008R2 database with an instead of trigger.
C#
Server srv = new Server("(local)");
Database db = srv.Databases["AdventureWorks2008R2"];
foreach (Table tb in db.Tables)
{
if (tb.HasInsteadOfTrigger == true)
{
Console.WriteLine("The " + tb.Name + " table has an instead of trigger");
}
}
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)
{
If ($tb.HasInsteadOfTrigger -eq $TRUE)
{
Write-Host "The" $tb.Name "table has an instead of trigger."
}
}