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)

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property HasUpdateTrigger As Boolean 
    Get
'Usage
Dim instance As Table 
Dim value As Boolean 

value = instance.HasUpdateTrigger

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

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
property bool HasUpdateTrigger {
    bool get ();
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
member HasUpdateTrigger : bool

function get HasUpdateTrigger () : boolean

Property Value

Type: System.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).

Remarks

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

Examples

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

C#

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");
   }
}

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.HasUpdateTrigger -eq $TRUE)
   {
      Write-Host "The" $tb.Name "table has an update trigger."
   }
}

See Also

Reference

Table Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Tables

CREATE TABLE (Transact-SQL)