You can define the attributes of a data value.
Core data type attributes that Teradata Database supports include the following.
Data Type Attribute | Description |
---|---|
NOT NULL | Specifies that the fields of a column must contain a value; they cannot be null. |
UPPERCASE | Specifies that character data for a column is stored as uppercase. |
[NOT] CASESPECIFIC | Specifies case for character data comparisons and collations. |
FORMAT | Controls the display of expressions, column data, and conversions between data types. |
TITLE | Defines a heading for displayed or printed results that is different from the column name, which is used by default. |
AS | Assigns a temporary name to an expression. |
NAMED | Assigns a temporary name to an expression. NAMED is a Teradata extension to the ANSI standard. For ANSI compliance, use AS instead of NAMED. |
DEFAULT | Specifies that a user-defined default value is to be inserted in the field when a value is not specified for a column in an INSERT statement. |
WITH DEFAULT | Specifies that a system-defined default value is to be inserted in the field when a value is not specified for a column in an INSERT statement. |
WITH TIME ZONE | Used with the TIME or TIMESTAMP data type to specify a TIME or TIMESTAMP value with a displacement from UTC as defined for the system. |
CHARACTER SET | Specifies the server character set for a character column. |
For a complete list of supported data type attributes and detailed information about each attribute, see Teradata Vantageā¢ - Data Types and Literals, B035-1143.