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