Storage and Constraint Attributes | Data Types and Literals | Teradata Vantage - 17.10 - Storage and Constraint Attributes - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1143-171K
Language
English (United States)

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: