This topic has not yet been rated - Rate this topic

Text Property

SQL Server 2008 R2

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The Text property exposes the Transact-SQL or other script that defines the referenced Microsoft SQL Server database object.

Syntax


object
.Text [=value]

Parts

object: An expression that evaluates to an object in the Applies To list
value: A string that satisfies the constraints on definition text for the referenced object

Data Type

String

Modifiable

Read/write when using a SQL Distributed Management Objects (SQL-DMO) object to create a SQL Server database object. Read-only when a SQL-DMO object references an existing database object.

Prototype (C/C++)

HRESULT GetText(SQLDMO_LPBSTR pRetVal);
HRESULT SetText(SQLDMO_LPCSTR NewValue);

Note
SQL-DMO strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference using SysFreeString.

Remarks

Constraints apply to strings used to set the Text property. For example, the Text property of a Check object contains an expression that evaluates to TRUE or FALSE. For a Trigger object, the Text property contains a Transact-SQL statement that creates a trigger when run. For more information, see documentation for the applicable SQL-DMO object.

Applies To:

Check Object	StoredProcedure Object
Default Object	Trigger Object
DRIDefault Object	UserDefinedFunction Object
Rule Object	View Object

Reference

Alter Method

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD