DatabaseDdlTrigger Properties
SQL Server 2012
The DatabaseDdlTrigger type exposes the following members.
| Name | Description | |
|---|---|---|
|
AnsiNullsStatus | Gets or sets the Boolean property value that specifies whether ISO NULL handling is enabled in the data definition language (DDL) trigger. |
|
|
AssemblyName | 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. |
|
|
BodyStartIndex | Gets the index value that represents the start of the DDL trigger text body. |
|
|
ClassName | 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. |
|
|
CreateDate | Gets the date and time when the database data definition language (DDL) trigger was created. |
|
|
DateLastModified | Gets the date and time when the database data definition language (DDL) trigger was last modified. |
|
|
DdlTriggerEvents | Gets or sets the set of data definition language (DDL) events that raise the database DDL trigger. |
|
|
ExecutionContext | 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. |
|
|
ExecutionContextUser | Gets or sets the database user that is the context used when the database DDL trigger executes. |
|
|
ExtendedProperties | Represents a collection of ExtendedProperty objects. Each ExtendedProperty object represents an extended property for the DatabaseDdlTrigger object. |
|
|
ID | Gets the ID value that uniquely identifies the database data definition language (DDL) trigger. |
|
|
ImplementationType | Gets or sets the implementation type for the database data definition language (DDL) trigger. |
|
|
IsEnabled | Gets or sets the Boolean property value that specifies whether the database data definition language (DDL) trigger is enabled. |
|
|
IsEncrypted | Gets or sets a Boolean property value that specifies whether the Transact-SQL batch or managed code is encrypted. |
|
|
IsSystemObject | Gets the Boolean property value that specifies whether the database data definition language (DDL) trigger is a system object. |
|
|
MethodName | 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. |
|
|
Name | Gets or sets a String value that specifies the name of the DDL trigger. (Overrides NamedSmoObject.Name.) |
|
|
NotForReplication | Gets or sets a Boolean property value that specifies whether the database data definition language (DDL) trigger is available for replication. |
|
|
Parent | Gets or sets the Database object that is the parent of the DatabaseDdlTrigger object. |
|
|
Properties | Gets a collection of Property objects that represent the object properties. (Inherited from SqlSmoObject.) |
|
|
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. |
|
|
State | Gets the state of the referenced object. (Inherited from SmoObjectBase.) |
|
|
Text | Gets the Transact-SQL statement that defines the database data definition language (DDL) trigger. |
|
|
TextBody | Gets or sets a String value that specifies the text body that is used to define the DDL trigger. (Overrides DdlTriggerBase.TextBody.) |
|
|
TextHeader | Gets or sets a String value that specifies the text header that is used to define the DDL trigger. (Overrides DdlTriggerBase.TextHeader.) |
|
|
TextMode | Gets or sets a Boolean value that specifies whether the DDL trigger is editable as text. (Overrides DdlTriggerBase.TextMode.) |
|
|
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Inherited from SqlSmoObject.) |
|
|
UserData | Gets or sets user-defined data associated with the referenced object. (Inherited from SmoObjectBase.) |
| Name | Description | |
|---|---|---|
|
ISfcSupportsDesignMode.IsDesignMode | Gets a Boolean value that specifies whether the trigger supports design mode. |
