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.

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

Syntax

'Declaration
Public Sub New ( _
    parent As Database, _
    name As String, _
    events As DatabaseDdlTriggerEventSet, _
    textBody As String _
)
'Usage
Dim parent As Database 
Dim name As String 
Dim events As DatabaseDdlTriggerEventSet 
Dim textBody As String 

Dim instance As New DatabaseDdlTrigger(parent, _
    name, events, textBody)

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

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

new : 
        parent:Database * 
        name:string * 
        events:DatabaseDdlTriggerEventSet * 
        textBody:string -> DatabaseDdlTrigger

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

Parameters

• parent
  Type: Microsoft.SqlServer.Management.Smo.Database
  A Database object value that specifies the parent of the DatabaseDdlTrigger object.

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

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

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

Examples

Calling Methods

See Also

Reference

DatabaseDdlTrigger Class

DatabaseDdlTrigger Overload

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

CREATE TRIGGER (Transact-SQL)

DDL Triggers