PhysicalDatatype Property (SQL-DMO)

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

Applies To

Syntax

object.PhysicalDatatype

Part	Description
object	Expression that evaluates to an object in the Applies To list

Remarks

For a Microsoft® SQL Server™ column created by using a base data type, the referencing Column object Datatype and PhysicalDatatype properties have identical values. For a SQL Server column created by 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.

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 by using SysFreeString.