Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Table.HasDeleteTrigger Property

Gets the Boolean property value that specifies whether the table has a delete 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 HasDeleteTrigger { get; }

Property Value

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

A delete trigger executes when a row of data is deleted.

The following code example shows how to check each table in the AdventureWorks2012 database to see if it has a delete trigger.

C#

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

Foreach (Table tb in db.Tables) 
{
   Console.WriteLine("The " + tb.Name + " table has a delete trigger:" + tb.HasDeleteTrigger.ToString());
}

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) 
{
   Write-Host "The" $tb.Name "table has a delete trigger:" $tb.HasDeleteTrigger
}

Community Additions

Show:
© 2015 Microsoft