DatabaseDdlTrigger Constructor (Database, String, DatabaseDdlTriggerEventSet, String, String, 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, _
    assemblyName As String, _
    className As String, _
    method As String _
)
'Usage
Dim parent As Database 
Dim name As String 
Dim events As DatabaseDdlTriggerEventSet 
Dim assemblyName As String 
Dim className As String 
Dim method As String 

Dim instance As New DatabaseDdlTrigger(parent, _
    name, events, assemblyName, className, _
    method)

public DatabaseDdlTrigger(
    Database parent,
    string name,
    DatabaseDdlTriggerEventSet events,
    string assemblyName,
    string className,
    string method
)

public:
DatabaseDdlTrigger(
    Database^ parent, 
    String^ name, 
    DatabaseDdlTriggerEventSet^ events, 
    String^ assemblyName, 
    String^ className, 
    String^ method
)

new : 
        parent:Database * 
        name:string * 
        events:DatabaseDdlTriggerEventSet * 
        assemblyName:string * 
        className:string * 
        method:string -> DatabaseDdlTrigger

public function DatabaseDdlTrigger(
    parent : Database, 
    name : String, 
    events : DatabaseDdlTriggerEventSet, 
    assemblyName : String, 
    className : String, 
    method : 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 DDL trigger responds.

• assemblyName
  Type: System.String
  A String value that specifies the name of the registered assembly that contains the user-defined function that runs when the DDL trigger is raised.

• className
  Type: System.String
  A String value that specifies the name of the class in the registered assembly.

• method
  Type: System.String
  A String value that specifies the method within the class that runs when the DDL trigger is raised.

Examples

Calling Methods

See Also

Reference

DatabaseDdlTrigger Class

DatabaseDdlTrigger Overload

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

CREATE TRIGGER (Transact-SQL)

DDL Triggers