DatabaseDdlTrigger 成員
The DatabaseDdlTrigger object represents a SQL Server database data definition language (DDL) trigger.
DatabaseDdlTrigger 型別公開下列成員。
建構函式
名稱 | 描述 | |
---|---|---|
DatabaseDdlTrigger() () () () | Initializes a new instance of the DatabaseDdlTrigger class. | |
DatabaseDdlTrigger(Database, String) | Initializes a new instance of the DatabaseDdlTrigger class on the specified database and with the specified name. | |
DatabaseDdlTrigger(Database, String, DatabaseDdlTriggerEventSet, String) | Initializes a new instance of the DatabaseDdlTrigger class on the specified database with the specified name. The trigger responds to the specified event set and runs the specified batch. | |
DatabaseDdlTrigger(Database, String, DatabaseDdlTriggerEventSet, String, String, String) | Initializes a new instance of the DatabaseDdlTrigger class on the specified database with the specified name. The trigger responds to the specified event set and runs the specified batch. |
頂端
方法
頂端
屬性
名稱 | 描述 | |
---|---|---|
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. | |
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (繼承自 SqlSmoObject。) | |
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. | |
IsTouched | Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (繼承自 SqlSmoObject。) | |
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 the name of the object. (繼承自 NamedSmoObject。) | |
NotForReplication | Gets or sets a Boolean property value that specifies whether the database data definition language (DDL) trigger is available for replication. | |
ObjectInSpace | Gets the Boolean property value that specifies whether the object exists in isolation, or whether it is directly or indirectly connected to the instance of SQL Server. (繼承自 SqlSmoObject。) | |
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. (繼承自 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. | |
ScalarResult | Gets the scalar result for the referenced object. (繼承自 SqlSmoObject。) | |
State | Gets the state of the referenced object. (繼承自 SmoObjectBase。) | |
Text | Gets the Transact-SQL statement that defines the database data definition language (DDL) trigger. | |
TextBody | Gets or sets the body text that is used in the definition of the database data definition language (DDL) trigger. (繼承自 DdlTriggerBase。) | |
TextHeader | Gets or sets the header text that is used in the definition of the database data definition language (DDL) trigger. (繼承自 DdlTriggerBase。) | |
TextMode | Gets or sets the Boolean property value that specifies whether the DatabaseDdlTrigger header is editable as text. (繼承自 DdlTriggerBase。) | |
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (繼承自 SqlSmoObject。) | |
UserData | Gets or sets user-defined data associated with the referenced object. (繼承自 SmoObjectBase。) |
頂端
明確繼承實作
名稱 | 描述 | |
---|---|---|
IAlienObjectDiscover | (繼承自 SqlSmoObject。) | |
IAlienObjectGetParent | (繼承自 SqlSmoObject。) | |
IAlienObjectGetProperty | (繼承自 SqlSmoObject。) | |
ISfcPropertyProviderGetPropertySet | (繼承自 SqlSmoObject。) | |
IAlienObjectGetUrn | (繼承自 SqlSmoObject。) | |
IAlienObjectResolve | (繼承自 SqlSmoObject。) | |
IAlienObjectSetProperty | (繼承自 SqlSmoObject。) |
頂端