RedGate.SQLCompare.Engine Namespace : Trigger Class

Trigger overview

Public Properties

After	True if the trigger is an after trigger.
AnsiNullsOn	True if the trigger was created with ansi nulls on.
Assembly	The CLR assembly for the DML trigger, if it is a CLR DML trigger.
AssemblyClass	The CLR assembly class name for the DML trigger, if it is a CLR DML trigger.
AssemblyMethod	The CLR assembly method name for the DML trigger, if it is a CLR DML trigger.
CLRObject	True if the trigger is a CLR trigger.
Database	The database to which the trigger belongs.
Delete	True if the trigger is a delete trigger.
Encrypted	True if the trigger definition is encrypted.
ExecuteAs	The user whose security context is to be used for the execution of the trigger. This is a SQL Server 2005 feature.
FirstDeleteTrigger	True if the trigger is the first delete trigger.
FirstInsertTrigger	True if the trigger is the first insert trigger.
FirstUpdateTrigger	True if the trigger is the first update trigger.
FullyQualifiedName	The fully-qualified name of the trigger.
ID	The identifier of the trigger.
Insert	True if the trigger is an insert trigger.
InsteadOf	True if the trigger is an instead of trigger.
IsDisabled	True if the trigger is disabled.
LastDeleteTrigger	True if the trigger is the last delete trigger.
LastInsertTrigger	True if the trigger is the last insert trigger.
LastUpdateTrigger	True if the trigger is the last update trigger.
Name	The name of the trigger.
ObjectType	Returns ObjectType.Trigger
Owner	The owner or the schema of the trigger.
QuotedIdentifierOn	True if the trigger was created with quoted identifiers on.
Text	The text of the trigger.
Update	True if the trigger is an update trigger.

Public Methods

Equals

Overloaded. Compares the trigger with a specified trigger.

See Also

Trigger Class  | RedGate.SQLCompare.Engine Namespace

 

 

---

© 2003 - 2007 Red Gate Software Ltd. All Rights Reserved.