You can define the attributes of a data value.
Core data type attributes that the database supports include the following.
| Data Type Attribute | Description |
|---|---|
| NOT NULL | Specifies that every field of a column must contain a non-null value. |
| UPPERCASE | Specifies that character data for a column is stored as uppercase. |
| [NOT] CASESPECIFIC | Specifies whether comparisons and collations of character data are case-specific.. |
| FORMAT | Controls the display of expressions, column data, and conversions between data types. |
| TITLE | Defines a heading for displayed results. (Default is column name.) |
| AS | Assigns a temporary name to an expression. |
| NAMED | Assigns a temporary name to an expression. 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.