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.Text Property

Gets the Transact-SQL statement that defines the database data definition language (DDL) trigger.

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

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Matrix)]
public string Text { get; }

Property Value

Type: String
A String value that specifies the actual text of the Transact-SQL statement that defines the database DDL trigger.

The Text property of the DatabaseDdlTrigger object is equivalent to the sql_statement argument that comes after the AS clause in the CREATE TRIGGER Transact-SQL statement.

Community Additions

ADD
Show:
© 2015 Microsoft