Export (0) Print
Expand All
Expand Minimize

Table.HasInsertTrigger Property

Gets the Boolean property value that specifies whether the table has an insert trigger.

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 HasInsertTrigger { get; }

Property Value

Type: Boolean
A Boolean value that specifies whether there are any insert triggers defined on the table.If True, there is an insert trigger defined on the table. Otherwise, False (default).

An insert trigger executes when a new row of data is inserted.

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

C#

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

foreach (Table tb in db.Tables) 
{
    if (tb.HasInsertTrigger == true)
   {
      Console.WriteLine("The " + tb.Name + " table has an insert 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.HasInsertTrigger -eq $TRUE)
   {
      Write-Host "The" $tb.Name "table has an insert trigger."
   }
}
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft