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
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