Share via

  • Artículo

HasDeleteTrigger Propiedad

Obtiene el valor de propiedad Boolean que especifica si la tabla tiene un desencadenador DELETE.

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

value = instance.HasDeleteTrigger

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

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

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

function get HasDeleteTrigger () : boolean

Valor de la propiedad

Tipo: System. . :: . .Boolean
Valor Boolean que especifica si la tabla tiene definido algún desencadenador DELETE.
Si es True, la tabla tiene definido un desencadenador DELETE. En caso contrario, es False (valor predeterminado).

Comentarios

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

Ejemplos

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

C#

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

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("AdventureWorks2008R2")

Foreach ($tb in $db.Tables) 
{
   Write-Host "The" $tb.Name "table has a delete trigger:" $tb.HasDeleteTrigger
}