Table.HasInsertTrigger Propiedad

Artículo
04/26/2013

Gets the Boolean property value that specifies whether the table has an insert trigger.

Espacio de nombres: Microsoft.SqlServer.Management.Smo
Ensamblado: Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Sintaxis

'Declaración
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property HasInsertTrigger As Boolean 
    Get
'Uso
Dim instance As Table 
Dim value As Boolean 

value = instance.HasInsertTrigger

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

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

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

function get HasInsertTrigger () : boolean

Valor de la propiedad

Tipo: System.Boolean
A Boolean value that specifies whether there are any insert triggers defined on the table.If True, there is an insert trigger defined on the table. Otherwise, False (default).

Comentarios

An insert trigger executes when a new row of data is inserted.

Ejemplos

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

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

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