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