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.