DatabaseDdlTrigger Properties

 

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

NameDescription
System_CAPS_pubpropertyAnsiNullsStatus

Gets or sets the Boolean property value that specifies whether ISO NULL handling is enabled in the data definition language (DDL) trigger.

System_CAPS_pubpropertyAssemblyName

Gets or sets the name of the assembly that contains the managed code that is executed when the data definition language (DDL) trigger is raised.

System_CAPS_pubpropertyBodyStartIndex

Gets the index value that represents the start of the DDL trigger text body.

System_CAPS_pubpropertyClassName

Gets or sets the name of the class in the assembly that contains the managed code that is executed when the data definition language (DDL) trigger is raised.

System_CAPS_pubpropertyCreateDate

Gets the date and time when the database data definition language (DDL) trigger was created.

System_CAPS_pubpropertyDateLastModified

Gets the date and time when the database data definition language (DDL) trigger was last modified.

System_CAPS_pubpropertyDdlTriggerEvents

Gets or sets the set of data definition language (DDL) events that raise the database DDL trigger.

System_CAPS_pubpropertyExecutionContext

Gets or sets the execution context type that is used by the database DDL trigger, by itself, by the caller, or by a specified login.

System_CAPS_pubpropertyExecutionContextUser

Gets or sets the database user that is the context used when the database DDL trigger executes.

System_CAPS_pubpropertyExecutionManager

(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyExtendedProperties

Represents a collection of ExtendedProperty objects. Each ExtendedProperty object represents an extended property for the DatabaseDdlTrigger object.

System_CAPS_pubpropertyID

Gets the ID value that uniquely identifies the database data definition language (DDL) trigger.

System_CAPS_pubpropertyImplementationType

Gets or sets the implementation type for the database data definition language (DDL) trigger.

System_CAPS_pubpropertyIsEnabled

Gets or sets the Boolean property value that specifies whether the database data definition language (DDL) trigger is enabled.

System_CAPS_pubpropertyIsEncrypted

Gets or sets a Boolean property value that specifies whether the Transact-SQL batch or managed code is encrypted.

System_CAPS_pubpropertyIsSystemObject

Gets the Boolean property value that specifies whether the database data definition language (DDL) trigger is a system object.

System_CAPS_pubpropertyMethodName

Gets or sets the name of the method that is owned by the class in the assembly, which is executed when the trigger is raised.

System_CAPS_pubpropertyName

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

System_CAPS_pubpropertyNotForReplication

Gets or sets a Boolean property value that specifies whether the database data definition language (DDL) trigger is available for replication.

System_CAPS_pubpropertyParent

Gets or sets the Database object that is the parent of the DatabaseDdlTrigger 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_pubpropertyText

Gets the Transact-SQL statement that defines the database data definition language (DDL) trigger.

System_CAPS_pubpropertyTextBody

Gets or sets a String value that specifies the text body that is used to define the DDL trigger.(Overrides DdlTriggerBase.TextBody.)

System_CAPS_pubpropertyTextHeader

Gets or sets a String value that specifies the text header that is used to define the DDL trigger.(Overrides DdlTriggerBase.TextHeader.)

System_CAPS_pubpropertyTextMode

Gets or sets a Boolean value that specifies whether the DDL trigger is editable as text.(Overrides DdlTriggerBase.TextMode.)

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: