Trigger Properties

Trigger Properties

 

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

NameDescription
System_CAPS_pubpropertyAnsiNullsStatus

Gets the Boolean property value that specifies whether ISO NULL handling is enabled in the trigger.

System_CAPS_pubpropertyAssemblyName

Gets or sets the name of the .NET assembly that is required by the referenced trigger.

System_CAPS_pubpropertyClassName

Gets or sets the name of the class that is called by the referenced trigger.

System_CAPS_pubpropertyCreateDate

Gets the date and time when the trigger was created.

System_CAPS_pubpropertyDateLastModified

Gets the date and time when the trigger was last modified.

System_CAPS_pubpropertyDelete

Gets or sets the Boolean property value that specifies whether the trigger is executed when records are deleted from the table.

System_CAPS_pubpropertyDeleteOrder

Gets or sets the order in which the trigger and the delete operation are executed.

System_CAPS_pubpropertyEvents

Gets the events that are associated with the trigger.

System_CAPS_pubpropertyExecutionContext

Gets or sets the execution context.

System_CAPS_pubpropertyExecutionContextPrincipal

Gets or sets the execution context principal.

System_CAPS_pubpropertyExtendedProperties

Gets the extended properties of the Trigger object.

System_CAPS_pubpropertyID

Gets the ID value that uniquely identifies the trigger.

System_CAPS_pubpropertyImplementationType

Gets or sets the implementation type of the trigger.

System_CAPS_pubpropertyInsert

Gets or sets the Boolean property value that specifies whether the trigger is fired when records are inserted into the table.

System_CAPS_pubpropertyInsertOrder

Gets or sets the order in which the trigger and the insert operation are executed.

System_CAPS_pubpropertyInsteadOf

Gets or sets a Boolean property that specifies whether the trigger runs instead of the insert, delete, or update operation.

System_CAPS_pubpropertyIsEnabled

Gets or sets the Boolean property that specifies whether the trigger is enabled.

System_CAPS_pubpropertyIsEncrypted

Gets or sets the Boolean property value that specifies whether the trigger is encrypted.

System_CAPS_pubpropertyIsSystemObject

Gets the Boolean property value that specifies whether the trigger is a system object.

System_CAPS_pubpropertyMethodName

Gets the method name for the trigger.

System_CAPS_pubpropertyName

Gets or sets a String value that specifies the name of the trigger.(Overrides NamedSmoObject.Name.)

System_CAPS_pubpropertyNotForReplication

Gets or sets a Boolean property value that specifies whether the trigger is included in replication operations.

System_CAPS_pubpropertyParent

Gets or sets the SqlSmoObject object that is the parent of the Trigger object.

System_CAPS_pubpropertyProperties

Gets a collection of Property objects that represent the object properties.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyQuotedIdentifierStatus

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.

System_CAPS_pubpropertyState

Gets the state of the referenced object.(Inherited from SmoObjectBase.)

System_CAPS_pubpropertyTextBody

Gets or sets the Transact-SQL string that defines the trigger.

System_CAPS_pubpropertyTextHeader

Gets or sets the header part of the Transact-SQL string that defines the trigger.

System_CAPS_pubpropertyTextMode

Gets or sets the Boolean property that specifies whether the text header is editable as text.

System_CAPS_pubpropertyUpdate

Gets or sets the Boolean property value that specifies whether the trigger is fired when records are updated in the table.

System_CAPS_pubpropertyUpdateOrder

Gets or sets the order in which the trigger and the update operation are executed.

System_CAPS_pubpropertyUrn

Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyUserData

Gets or sets user-defined data associated with the referenced object.(Inherited from SmoObjectBase.)

Return to top
Show:
© 2016 Microsoft