Syntax - Advanced SQL Engine - Teradata Database

column_name data_type_declaration
  [ data_type_attribute |
    column_storage_attribute |
    column_constraint_attribute
  ] [...]

data_type_declaration

The data type of a column, such as BYTE or FLOAT.

For more information, see Data Type Phrases.

data_type_attribute

Attributes for a column, such as a default value to insert when an INSERT statement omits the value.

For more information, see Core Data Type Attributes.

column_storage_attribute

Compress certain values and nulls for one or more columns of a table.

For more information, see:

• Storage and Constraint Attributes
• COMPRESS and DECOMPRESS Phrases

column_constraint_attribute

Column-level integrity constraints, such as PRIMARY KEY.

For more information, see:

• Storage and Constraint Attributes
• Column and Table Constraints
• “ALTER TABLE” and “CREATE TABLE” in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144