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 SQL Data Types and Literals.