Table.HasAfterTrigger-Eigenschaft

Gets the Boolean property value that specifies whether the table has any after triggers.

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 HasAfterTrigger As Boolean 
    Get
'Usage
Dim instance As Table 
Dim value As Boolean 

value = instance.HasAfterTrigger

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

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

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

function get HasAfterTrigger () : boolean

Eigenschaftswert

Typ: System.Boolean
A Boolean value that specifies whether there are any after triggers defined on the table.If True, at least one of the table's triggers is defined as an after trigger.If False (default), there are no after triggers defined on the table.

Hinweise

An after trigger runs on successful completion of the triggering statement. All referential cascade actions and constraint checks also must succeed before this trigger executes.

Beispiele

The following code example shows how to check each table in the AdventureWorks2012 database to see if it has any after triggers.

C#

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

Foreach (Table tb in db.Tables) 
{
   Console.WriteLine("The " + tb.Name + " table has after triggers:" + tb.HasAfterTrigger.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 after triggers:" $tb.HasAfterTrigger
}

Siehe auch

Verweis

Table Klasse

Microsoft.SqlServer.Management.Smo-Namespace

Andere Ressourcen

Tabellen

CREATE TABLE (Transact-SQL)