通过

  • 项目

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."
   }
}