Dela via

  • Artikel

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

  • name
    Type: System.String
    A String value that specifies the name of the database data definition language (DDL) trigger.
  • 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