Schema Rowsets
UDTs and UDMs are visible through OLE DB Provider for Teradata schema rowsets as shown in the following table:
|
Schema Rowset |
Description |
|
TABLES |
Contains one row for each UDT. These rows have the provider-specific value “TYPE” in the TABLE_TYPE column and the name of the UDT in the TABLE_NAME column. |
|
COLUMNS |
Rows corresponding to columns containing UDTs have the DBTYPE_UDT type indicator in their DATA_TYPE column. Also, the DBCOLUMNFLAGS_ISFIXEDLENGTH bit is not set in the COLUMN_FLAGS column for these rows. |
|
PROCEDURES |
Contains one row for each UDM. These rows have the PROCEDURE_TYPE column set to DB_PT_FUNCTION. |
|
PROCEDURE_PARAMETERS |
Rows corresponding to UDTs have the DBTYPE_UDT type indicator in their DATA_TYPE column. Also, the name of the UDT is placed into the TYPE_NAME column. |