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.
Restrictions apply to some attributes. For example, you cannot use the WITH DEFAULT attribute with UDT data types. For more information, see:
- Default Value Control Phrases
- Data Type Formats and Format Phrases
- Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144