The following table lists the main Teradata SQL data type attributes.
| Data Type Attribute | ANSI | Teradata Extension to ANSI |
|---|---|---|
| NOT NULL | X | |
| UPPERCASE | X | |
| [NOT] CASESPECIFIC | X | |
| FORMAT format_string | X | |
| TITLE char_string | X | |
| AS name | X | |
| NAMED name | X | |
| DEFAULT value | X | |
| DEFAULT USER | X | |
| DEFAULT DATE | X | |
| DEFAULT TIME | X | |
| DEFAULT NULL | X | |
| WITH DEFAULT | X | |
| WITH TIME ZONE | X | |
| CHARACTER SET | X |
The expression “data type attributes” is non-ANSI, as are attributes such as TITLE and FORMAT.
Attributes may have restrictions. See: