Конструктор 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
)
Параметры
- parent
Тип: Microsoft.SqlServer.Management.Smo.Server
A Server object value that specifies the parent of the ServerDdlTrigger object.
- name
Тип: System.String
A String value that specifies the name of the server data definition language (DDL) trigger.
- events
Тип: Microsoft.SqlServer.Management.Smo.ServerDdlTriggerEventSet
A ServerDdlTriggerEventSet object that specifies the DDL events to which the trigger responds.
- textBody
Тип: System.String
A String value that specifies the Transact-SQL batch statement that runs when the trigger has been raised.
Примеры
Создание, изменение и удаление триггеров
См. также
Справочник
Пространство имен Microsoft.SqlServer.Management.Smo