DatabaseDdlTrigger 类
The DatabaseDdlTrigger object represents a SQL Server database data definition language (DDL) trigger.
继承层次结构
System. . :: . .Object
Microsoft.SqlServer.Management.Smo. . :: . .SmoObjectBase
Microsoft.SqlServer.Management.Smo. . :: . .SqlSmoObject
Microsoft.SqlServer.Management.Smo. . :: . .NamedSmoObject
Microsoft.SqlServer.Management.Smo. . :: . .ScriptNameObjectBase
Microsoft.SqlServer.Management.Smo. . :: . .DdlTriggerBase
Microsoft.SqlServer.Management.Smo..::..DatabaseDdlTrigger
命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)
语法
声明
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<PhysicalFacetAttribute(PhysicalFacetOptions.ReadOnly)> _
<SfcElementTypeAttribute("DdlTrigger")> _
Public NotInheritable Class DatabaseDdlTrigger _
Inherits DdlTriggerBase _
Implements IExtendedProperties
用法
Dim instance As DatabaseDdlTrigger
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[PhysicalFacetAttribute(PhysicalFacetOptions.ReadOnly)]
[SfcElementTypeAttribute("DdlTrigger")]
public sealed class DatabaseDdlTrigger : DdlTriggerBase,
IExtendedProperties
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::CheckOnSchedule)]
[PhysicalFacetAttribute(PhysicalFacetOptions::ReadOnly)]
[SfcElementTypeAttribute(L"DdlTrigger")]
public ref class DatabaseDdlTrigger sealed : public DdlTriggerBase,
IExtendedProperties
[<SealedAttribute>]
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
[<PhysicalFacetAttribute(PhysicalFacetOptions.ReadOnly)>]
[<SfcElementTypeAttribute("DdlTrigger")>]
type DatabaseDdlTrigger =
class
inherit DdlTriggerBase
interface IExtendedProperties
end
public final class DatabaseDdlTrigger extends DdlTriggerBase implements IExtendedProperties
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 继承。) |
页首
注释
DDL triggers run a Transact-SQL or user-defined function in response to certain DDL events.
SMO provides programmatic access to allow management of all DDL trigger functionality with the DatabaseDdlTrigger object and the ServerDdlTrigger object.
Database DDL triggers respond to events within the scope of the database and server DDL triggers respond to events within the scope of the SQL Server instance.
To get DatabaseDdlTrigger object properties, users can be a member of the public fixed server role.
To set DatabaseDdlTrigger object properties, users must have ALTER ANY DATABASE DDL TRIGGER permission on the database.
To create a DDL trigger, users must have ALTER ANY DATABASE DDL TRIGGER permission on the database.
To drop a DDL trigger, users must have ALTER ANY DATABASE DDL TRIGGER permission on the database.
To enable or disable the DDL trigger, users must have ALTER ANY DATABASE DDL TRIGGER permission on the database.
Thread Safety
此类型的任何公共静态(Microsoft Visual Basic 中的 Shared)成员在多线程操作中是安全的。 不保证所有实例成员都对于线程安全的。
线程安全
此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。