ServerDdlTrigger Constructor (Server, String, ServerDdlTriggerEventSet, String)
Initializes a new instance of the ServerDdlTrigger 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 Server, _
name As String, _
events As ServerDdlTriggerEventSet, _
textBody As String _
)
public ServerDdlTrigger (
Server parent,
string name,
ServerDdlTriggerEventSet events,
string textBody
)
public:
ServerDdlTrigger (
Server^ parent,
String^ name,
ServerDdlTriggerEventSet^ events,
String^ textBody
)
public ServerDdlTrigger (
Server parent,
String name,
ServerDdlTriggerEventSet events,
String textBody
)
public function ServerDdlTrigger (
parent : Server,
name : String,
events : ServerDdlTriggerEventSet,
textBody : String
)
參數
- parent
A Server object value that specifies the parent of the ServerDdlTrigger object.
- name
A String value that specifies the name of the server data definition language (DDL) trigger.
- events
A ServerDdlTriggerEventSet 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: Create, Alter, and Remove a Trigger in Visual Basic .NET
平台
開發平台
如需受支援的平台清單,請參閱<安裝 SQL Server 2005 的硬體和軟體需求>。
目標平台
如需受支援的平台清單,請參閱<安裝 SQL Server 2005 的硬體和軟體需求>。
請參閱
參考
ServerDdlTrigger Class
ServerDdlTrigger Members
Microsoft.SqlServer.Management.Smo Namespace
其他資源
Creating, Altering, and Removing Triggers
DDL 觸發程序
CREATE TRIGGER (Transact-SQL)