UDT Data Type

Database
Enthusiast

UDT Data Type

We can define a distinct UDT(User Defined Type) data type named "dollar" as:

CREATE TYPE dollar
AS DECIMAL(8,2)
FINAL;

What is the significance of the word "FINAL"?
Is it part of the syntax or we can define without using "FINAL" also.
Also , can anyone cite an example of a Structured UDT?How to define one?
Tags (1)
1 REPLY
Enthusiast

Re: UDT Data Type

FINAL is part of the ANSI/ISO standard SQL syntax. In Teradata, its only purpose is to conform to the standard syntax for declaring distinct types. In implementations that support type inheritance, it additionally signifies that the type cannot be used as a base type for defining a subtype. Teradata doesn't support type inheritance.

For examples of structured UDTs, see the Teradata SQL reference manual or any textbook on standard SQL.