UserDefinedTypes schema collection returns information about USER DEFINED TYPE objects by accessing the Advanced SQL Engine Data Dictionary views. It will access DBC.TABLES[V]X if UseXViews is set to true; otherwise it will access DBC.COLUMNS[V] Data Dictionary view.

Column Name	Data Type	Description
UDT_CATALOG	String	This field is always set to EMPTY.
UDT_SCHEMA	String	Returns the name of the DATABASE in which USER DEFINED TYPE object resides.
UDT_NAME	String	Returns the name of the USER DEFINED TYPE object.
CREATOR_NAME	String	Returns the name of the user who created the USER DEFINED TYPE object.
DATE_CREATED	DateTime	Returns the date and time the USER DEFINED TYPE was created.
DATE_MODIFIED	DateTime	Returns the date and time the USER DEFINED TYPE was last updated.
UDT_DEFINITION	String	Returns the text of the most recent USER DEFINED TYPE definition statement.
REMARKS	String	Returns user-supplied text or commentary on the USER DEFINED TYPE object.

UserDefinedFunctions Schema Collection can be filtered or restricted to:

Restriction Column Name	Restriction Number	Description
CREATOR_NAME	1	This restriction can be set to a valid USER name.
UDT_NAME	2	This restriction can be set to a valid USER DEFINED TYPE object name.

UserDefinedTypes Schema collection rows are ordered by:

Column Name	Description
CREATOR_NAME	Ascending case sensitive sort order.  For example A through Z followed by a through z.
UDT_NAME	Ascending case sensitive sort order.