ServerDdlTrigger 构造函数 (Server, String, ServerDdlTriggerEventSet, String)

Initializes a new instance of the ServerDdlTrigger class on the specified database that has the specified name. The trigger responds to the specified event set and runs the specified batch.

命名空间:  Microsoft.SqlServer.Management.Smo
程序集:  Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)

语法

声明
Public Sub New ( _
    parent As Server, _
    name As String, _
    events As ServerDdlTriggerEventSet, _
    textBody As String _
)
用法
Dim parent As Server 
Dim name As String 
Dim events As ServerDdlTriggerEventSet 
Dim textBody As String 

Dim instance As New ServerDdlTrigger(parent, _
    name, events, textBody)
public ServerDdlTrigger(
    Server parent,
    string name,
    ServerDdlTriggerEventSet events,
    string textBody
)
public:
ServerDdlTrigger(
    Server^ parent, 
    String^ name, 
    ServerDdlTriggerEventSet^ events, 
    String^ textBody
)
new : 
        parent:Server * 
        name:string * 
        events:ServerDdlTriggerEventSet * 
        textBody:string -> ServerDdlTrigger
public function ServerDdlTrigger(
    parent : Server, 
    name : String, 
    events : ServerDdlTriggerEventSet, 
    textBody : String
)

参数

  • name
    类型:System.String
    A String value that specifies the name of the server data definition language (DDL) trigger.
  • textBody
    类型:System.String
    A String value that specifies the Transact-SQL batch statement that runs when the trigger has been raised.

示例

创建、更改和删除触发器

请参阅

参考

ServerDdlTrigger 类

ServerDdlTrigger 重载

Microsoft.SqlServer.Management.Smo 命名空间

其他资源

DDL 触发器

CREATE TRIGGER (Transact-SQL)