A distinct UDT is based on a single, predefined data type such as INTEGER or VARCHAR. It redefines an already‑defined SQL data type.
Example
Define Salary as a Decimal(9,2), but with a function that prevents someone from entering a value of less than 20,000 or more than 2,000,000.