DatabaseDdlTrigger Constructor (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.

命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

语法

声明
Public Sub New ( _
    parent As Database, _
    name As String, _
    events As DatabaseDdlTriggerEventSet, _
    textBody As String _
)

public DatabaseDdlTrigger (
    Database parent,
    string name,
    DatabaseDdlTriggerEventSet events,
    string textBody
)

public:
DatabaseDdlTrigger (
    Database^ parent, 
    String^ name, 
    DatabaseDdlTriggerEventSet^ events, 
    String^ textBody
)

public DatabaseDdlTrigger (
    Database parent, 
    String name, 
    DatabaseDdlTriggerEventSet events, 
    String textBody
)

public function DatabaseDdlTrigger (
    parent : Database, 
    name : String, 
    events : DatabaseDdlTriggerEventSet, 
    textBody : String
)

参数

• parent
  A Database object value that specifies the parent of the DatabaseDdlTrigger object.

• name
  A String value that specifies the name of the database data definition language (DDL) trigger.

• events
  A DatabaseDdlTriggerEventSet object that specifies the DDL events to which the trigger responds.

• textBody
  A String value that specifies the Transact-SQL batch statement that runs when the trigger has been raised.

备注

仅 Microsoft .NET Framework 的 2.0 版本支持此命名空间、类或成员。

示例

How to: Construct an Object in Visual Basic .NET

平台

开发平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

目标平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

请参阅

参考

DatabaseDdlTrigger Class
DatabaseDdlTrigger Members
Microsoft.SqlServer.Management.Smo Namespace

其他资源

CREATE TRIGGER (Transact-SQL)
DDL 触发器