Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Gets or sets the Transact-SQL statement that defines the server data definition language (DDL) trigger.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Expensive Or SfcPropertyFlags.Standalone)> _
Public ReadOnly Property Text As String
Get
'Usage
Dim instance As ServerDdlTrigger
Dim value As String
value = instance.Text
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)]
public string Text { get; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Expensive|SfcPropertyFlags::Standalone)]
public:
property String^ Text {
String^ get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)>]
member Text : string
function get Text () : String
Property Value
Type: System.String
A String value that specifies the actual text of the Transact-SQL statement that defines the server DDL trigger.
Remarks
The Text property of the ServerDdlTrigger object is equivalent to the sql_statement argument that comes after the AS clause in the CREATE TRIGGER Transact-SQL statement.
Examples
Creating, Altering, and Removing Triggers
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace