Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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)

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


Type: Microsoft.SqlServer.Management.Smo.Database

A Database object value that specifies the parent of the DatabaseDdlTrigger object.

Type: System.String

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

Type: Microsoft.SqlServer.Management.Smo.DatabaseDdlTriggerEventSet

A DatabaseDdlTriggerEventSet object that specifies the DDL events to which the trigger responds.

Type: System.String

A String value that specifies the Transact-SQL batch statement that runs when the trigger has been raised.

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft