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 觸發程序