Trigger.TextBody Property

 

Applies To: SQL Server 2016 Preview

Gets or sets the Transact-SQL string that defines the trigger.

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

Syntax

[SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Expensive | SfcPropertyFlags.Standalone | SfcPropertyFlags.SqlAzureDatabase | SfcPropertyFlags.Design | SfcPropertyFlags.Matrix)]
public string TextBody { get; set; }
public:
[SfcPropertyAttribute(SfcPropertyFlags::None | SfcPropertyFlags::Expensive | SfcPropertyFlags::Standalone | SfcPropertyFlags::SqlAzureDatabase | SfcPropertyFlags::Design | SfcPropertyFlags::Matrix)]
property String^ TextBody {
    virtual String^ get() sealed;
    virtual void set(String^ value) sealed;
}
[<SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Expensive | SfcPropertyFlags.Standalone | SfcPropertyFlags.SqlAzureDatabase | SfcPropertyFlags.Design | SfcPropertyFlags.Matrix)>]
abstract TextBody : string with get, set
[<SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Expensive | SfcPropertyFlags.Standalone | SfcPropertyFlags.SqlAzureDatabase | SfcPropertyFlags.Design | SfcPropertyFlags.Matrix)>]
override TextBody : string with get, set
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Expensive Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design Or SfcPropertyFlags.Matrix)>
Public Property TextBody As String

Property Value

Type: System.String

A String value that specifies the Transact-SQL definition of the trigger .

Implements

ITextObject.TextBody

Examples

Legacy Code Example

Creating, Altering, and Removing Triggers

See Also

Trigger Class
Microsoft.SqlServer.Management.Smo Namespace

CREATE TRIGGER (Transact-SQL)
Unable to find linked topic 'fface999-424a-4815-bc04-cbbd168c65ab'.

Return to top