Creates a user-defined type that is constructed directly from a predefined Vantage data type.
ANSI Compliance
This statement is ANSI SQL:2011 compliant, but includes non-ANSI Teradata extensions.
Other SQL dialects support similar non-ANSI standard statements with names such as the following:
- CREATE DISTINCT TYPE
Required Privileges
You must have either the UDTTYPE or UDTMETHOD privilege on the SYSUDTLIB database to create a distinct UDT.
If the type definition includes a set of method signatures, then you must also have the UDTMETHOD privilege on the SYSUDTLIB database.
Privileges Granted Automatically
None.