The following table lists Teradata SQL storage and constraint attributes.
Attribute Family | Data Type Attribute | ANSI | Teradata Extension to ANSI |
---|---|---|---|
Column Storage | COMPRESS | X | |
COMPRESS NULL | X | ||
COMPRESS constant_value | X | ||
COMPRESS (multivalue_list) | X | ||
COMPRESS USING compress_udf DECOMPRESS USING decompress_udf | X | ||
Column Constraints | CONSTRAINT | X | |
CONSTRAINT UNIQUE | X | ||
CONSTRAINT PRIMARY KEY | X | ||
CONSTRAINT CHECK (boolean_condition) | X | ||
CONSTRAINT REFERENCES table_name column_name | X | ||
Table Constraints | FOREIGN KEY (column_name_list) | X | |
PRIMARY KEY | X | ||
UNIQUE | X | ||
CHECK (boolean_expression) | X | ||
REFERENCES table_name
[(column_name_list)] |
X |
Restrictions apply to some attributes such as COMPRESS. For more information, see:
- COMPRESS and DECOMPRESS Phrases.
- Teradata Vantageā¢ - SQL Data Definition Language Syntax and Examples, B035-1144