Proprietà Table.HasInsteadOfTrigger

Articolo
04/26/2013

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

Spazio dei nomi Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

'Dichiarazione
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property HasInsteadOfTrigger As Boolean 
    Get
'Utilizzo
Dim instance As Table 
Dim value As Boolean 

value = instance.HasInsteadOfTrigger

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

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

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

function get HasInsteadOfTrigger () : boolean

Valore proprietà

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

Osservazioni

An "instead of" trigger runs instead of the triggering statement.

Esempi

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

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

foreach (Table tb in db.Tables) 
{
    if (tb.HasInsteadOfTrigger == true)
   {
      Console.WriteLine("The " + tb.Name + " table has an instead of 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.HasInsteadOfTrigger -eq $TRUE)
   {
      Write-Host "The" $tb.Name "table has an instead of trigger."
   }
}