PhysicalDatatype Property

SQL-DMO

SQL-DMO

PhysicalDatatype Property

The PhysicalDatatype property returns the name of the base data type for the referenced column.

Applies To
Column Object
Syntax

object.PhysicalDatatype

Parts

object

Expression that evaluates to an object in the Applies To list

Data Type

String

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetPhysicalDatatype(SQLDMO_LPBSTR pRetVal);

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

For a Microsoft® SQL Server™ 2000 column created using a base data type, the referencing Column object Datatype and PhysicalDatatype properties have identical values. For a SQL Server column created using a user-defined data type, the referencing Column object Datatype property returns the name of the user-defined data type. The PhysicalDatatype property reports the SQL Server base data type.