The GetDatatypeByName method returns an object that references the named system or user-defined data type.
object.GetDatatypeByName( Datatype ) as Variant
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
HRESULT GetDatatypeByName(
SQLDMO_LPCSTR szName,
LPSQLDMOSTDOBJECT* ppDBObject);
A variant that references an object
Use the TypeOf property to determine the nature of the data type returned. Interpret the TypeOf property using SQLDMO_OBJECT_TYPE.