15.00 - Properties of Domains In Teradata Database - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Properties of Domains In Teradata Database

Domains in Teradata Database are defined to have the following properties:

  • A domain defines the set of possible values that can be written to a table column.
  • The values of a domain cannot be decomposed to component values; they are atomic.
  • Note that this is not true for domains having INTERVAL, TIMESTAMP, or structured UDT data types, which are not atomic, but the concept generally holds true otherwise.

  • A domain must have a name.
  • A domain must have an assigned data type.