ServerDdlTrigger.Text Property

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

命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

语法

声明
Public ReadOnly Property Text As String
public string Text { get; }
public:
property String^ Text {
    String^ get ();
}
/** @property */
public String get_Text ()
public function get Text () : String

属性值

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

备注

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.

示例

How to: Create, Alter, and Remove a Trigger in Visual Basic .NET

线程安全

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

平台

开发平台

有关支持的平台列表,请参阅安装 SQL Server 2005 的硬件和软件要求。

目标平台

有关支持的平台列表,请参阅安装 SQL Server 2005 的硬件和软件要求。

请参阅

参考

ServerDdlTrigger Class
ServerDdlTrigger Members
Microsoft.SqlServer.Management.Smo Namespace

其他资源

Creating, Altering, and Removing Triggers
DDL 触发器
CREATE TRIGGER (Transact-SQL)