Datatype Property (SQL-DMO)

The Datatype property exposes the data type name for the referenced column.

Applies To

Syntax

object.Datatype [= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list
value	Text string identifying a Microsoft® SQL Server™ system or user-defined data type

Remarks

The Datatype property may not completely define the data type of a column. Columns requiring width specification, such as varchar, or specification of scale and precision, such as decimal, are defined by using the Datatype property in concert with Length, NumericPrecision, and NumericScale properties.

The property is read/write for all columns. Changing the data type of an existing column is constrained by any data present and can fail if data conversion would result in data loss.

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetDatatype(SQLDMO_LPBSTR pRetVal);

HRESULT SetDatatype(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.

Length Property	NumericScale Property
NumericPrecision Property