Text Property (SQL-DMO)

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

Applies To

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

Syntax

object.Text [= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list
value	String satisfying the constraints on definition text for the referenced object

Remarks

Constraints apply to strings used to set the Text property. For example, the Text property of a Check object contains only 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 executed. For more information, see documentation for the applicable SQL-DMO object.

Data Type

String

Modifiable

Read/write when using a 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 by using SysFreeString.