17.10 - Syntax - 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)
column_name data_type_declaration
  [ data_type_attribute |
    column_storage_attribute |
    column_constraint_attribute
  ] [...]

Syntax Elements

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:
column_constraint_attribute
Column-level integrity constraints, such as PRIMARY KEY.
For more information, see: