Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Table.HasUpdateTrigger Property

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

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

public bool HasUpdateTrigger { get; }

Property Value

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

An update trigger executes when a row of data is updated.

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


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

foreach (Table tb in db.Tables) 
    if (tb.HasUpdateTrigger == true)
      Console.WriteLine("The " + tb.Name + " table has an update trigger");


$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.HasUpdateTrigger -eq $TRUE)
      Write-Host "The" $tb.Name "table has an update trigger."
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft