GetDatatypeByName Method

SQL-DMO

SQL-DMO

GetDatatypeByName Method

The GetDatatypeByName method returns an object that references the named system or user-defined data type.

Applies To
Database Object
Syntax

object.GetDatatypeByName( Datatype ) as Variant

Parts

object

Expression that evaluates to an object in the Applies To list

Datatype

String that specifies a system or user-defined data type by name

Prototype (C/C++)

HRESULT GetDatatypeByName(
SQLDMO_LPCSTR szName,
LPSQLDMOSTDOBJECT* ppDBObject);

Returns

A variant that references an object

Remarks

Use the TypeOf property to determine the nature of the data type returned. Interpret the TypeOf property using SQLDMO_OBJECT_TYPE.