This section describes the user-defined type (UDT) data type.
For information about the VARIANT_TYPE UDT, see VARIANT_TYPE Data Type.
The UDT data type represents a custom data type for modeling the structure and behavior of real-world entities used by applications.
ANSI Compliance
UDTs are ANSI SQL:2011 compliant.
Required Privileges
To create a table that has a UDT column, you must have the UDTUSAGE, UDTTYPE, or UDTMETHOD privilege on the SYSUDTLIB database, or have the UDTUSAGE privilege on the specified UDT.
To perform a query on a UDT column, you must have the UDTUSAGE privilege on the specified UDT.