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

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)]
public bool HasDeleteTrigger { get; }

Property Value

Type: System.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
}
Return to top
Show:
© 2016 Microsoft