User-defined data types
The following table summarizes the UDTs that the database server supports.
| Data type | Explanation |
|---|---|
| Distinct | Has the same internal representation as the source data type on which it is based but has different casts and functions defined over it than those on the source type |
| Opaque | Fundamental data type that the user defines A fundamental data type is atomic; that is, it cannot be broken into smaller pieces, and it can serve as the building block for other data types. |
In an ANSI-compliant database, columns defined using user-defined types should be in the owner.object format.