Export (0) Print
Expand All
Expand Minimize

Table.HasInsteadOfTrigger Property

Gets the Boolean property value that specifies whether the table has any instead of triggers.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

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

Property Value

Type: Boolean
A Boolean value that specifies whether there are any instead of triggers defined on the table.If True, at least one of the table's triggers is defined as an instead of trigger. Otherwise, False (default).

An "instead of" trigger runs instead of the triggering statement.

The following code example shows how to list each table in the AdventureWorks2012 database with an instead of trigger.

C#

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

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("AdventureWorks2012")

Foreach ($tb in $db.Tables) 
{
   If ($tb.HasInsteadOfTrigger -eq $TRUE)
   {
      Write-Host "The" $tb.Name "table has an instead of trigger."
   }
}
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft