Export (0) Print
Expand All

Trigger Properties

The Trigger type exposes the following members.

  Name Description
Public property AnsiNullsStatus Gets the Boolean property value that specifies whether ISO NULL handling is enabled in the trigger.
Public property AssemblyName Gets or sets the name of the .NET assembly that is required by the referenced trigger.
Public property ClassName Gets or sets the name of the class that is called by the referenced trigger.
Public property CreateDate Gets the date and time when the trigger was created.
Public property DateLastModified Gets the date and time when the trigger was last modified.
Public property Delete Gets or sets the Boolean property value that specifies whether the trigger is executed when records are deleted from the table.
Public property DeleteOrder Gets or sets the order in which the trigger and the delete operation are executed.
Public property Events Gets the events that are associated with the trigger.
Public property ExecutionContext Gets or sets the execution context.
Public property ExecutionContextPrincipal Gets or sets the execution context principal.
Public property ExtendedProperties Gets the extended properties of the Trigger object.
Public property ID Gets the ID value that uniquely identifies the trigger.
Public property ImplementationType Gets or sets the implementation type of the trigger.
Public property Insert Gets or sets the Boolean property value that specifies whether the trigger is fired when records are inserted into the table.
Public property InsertOrder Gets or sets the order in which the trigger and the insert operation are executed.
Public property InsteadOf Gets or sets a Boolean property that specifies whether the trigger runs instead of the insert, delete, or update operation.
Public property IsEnabled Gets or sets the Boolean property that specifies whether the trigger is enabled.
Public property IsEncrypted Gets or sets the Boolean property value that specifies whether the trigger is encrypted.
Public property IsSystemObject Gets the Boolean property value that specifies whether the trigger is a system object.
Public property MethodName Gets the method name for the trigger.
Public property Name Gets or sets a String value that specifies the name of the trigger. (Overrides NamedSmoObject.Name.)
Public property NotForReplication Gets or sets a Boolean property value that specifies whether the trigger is included in replication operations.
Public property Parent Gets or sets the SqlSmoObject object that is the parent of the Trigger object.
Public property Properties Gets a collection of Property objects that represent the object properties. (Inherited from SqlSmoObject.)
Public property QuotedIdentifierStatus Gets or sets a Boolean property value that specifies whether identifiers delimited by double quotation marks are Transact-SQL reserved keywords or contain characters not usually allowed by the Transact-SQL syntax rules.
Public property State Gets the state of the referenced object. (Inherited from SmoObjectBase.)
Public property TextBody Gets or sets the Transact-SQL string that defines the trigger.
Public property TextHeader Gets or sets the header part of the Transact-SQL string that defines the trigger.
Public property TextMode Gets or sets the Boolean property that specifies whether the text header is editable as text.
Public property Update Gets or sets the Boolean property value that specifies whether the trigger is fired when records are updated in the table.
Public property UpdateOrder Gets or sets the order in which the trigger and the update operation are executed.
Public property Urn Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Inherited from SqlSmoObject.)
Public property UserData Gets or sets user-defined data associated with the referenced object. (Inherited from SmoObjectBase.)
Top

  Name Description
Explicit interface implemetation Private property ISfcSupportsDesignMode.IsDesignMode Gets a Boolean value that specifies whether the trigger supports design mode.
Top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft