ServerDdlTrigger-Konstruktor (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.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public Sub New ( _
    parent As Server, _
    name As String, _
    events As ServerDdlTriggerEventSet, _
    textBody As String _
)
'Usage
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
)

Parameter

• parent
  Typ: Microsoft.SqlServer.Management.Smo.Server
  A Server object value that specifies the parent of the ServerDdlTrigger object.

• name
  Typ: System.String
  A String value that specifies the name of the server data definition language (DDL) trigger.

• events
  Typ: Microsoft.SqlServer.Management.Smo.ServerDdlTriggerEventSet
  A ServerDdlTriggerEventSet object that specifies the DDL events to which the trigger responds.

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

Beispiele

Erstellen, Ändern und Löschen von Trigger

Siehe auch

Verweis

ServerDdlTrigger Klasse

ServerDdlTrigger-Überladung

Microsoft.SqlServer.Management.Smo-Namespace

Andere Ressourcen

DDL-Trigger

CREATE TRIGGER (Transact-SQL)