16.20 - Storage and Constraint Attributes - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Types and Literals

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1143-162K

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 further details, see: