CREATE TABLE (Queue Table Form) SQL Statement | Teradata Vantage - Syntax - Advanced SQL Engine - Teradata Database

{ CREATE table_kind | CT } table_specification,
  QUEUE [ table_option [,...] ]
  ( QITS_specification )
  [ index_specification [[,]...] ] [;]

table_kind

[ SET | MULTISET ]

table_specification

[ database_name. | user_name. ] table_name

table_option

{ MAP = map_name |
  [NO] FALLBACK [ PROTECTION ] |
  NO JOURNAL |
  FREESPACE = integer [ PERCENT ] |
  data_block_size |
  blockcompression |
  CHECKSUM = { ON | OFF | DEFAULT }
}

QITS_specification

QITS_column_name TIMESTAMP [ (6) ] NOT NULL DEFAULT
  CURRENT_TIMESTAMP [ (6) ]
  [ data_type_attribute [...] |
    [ CONSTRAINT name ] CHECK ( boolean_condition )
  ]
  QITS_attribute [,...]

index_specification

{ [ UNIQUE ] INDEX [ index_name ] ( index_column_name [,...] ) |

  [ UNIQUE ] PRIMARY INDEX [ index_name ] ( primary_index_column [,...] ) |
  
  INDEX [ index_name ] ( index_column_name [,...] )
    ORDER BY [ VALUES | HASH ] ( order_column_name )
}

data_block_size

{ DATABLOCKSIZE = integer [ BYTE[S] | KBYTE[S] | KILOBYTE[S] ] |
  [ MINIMUM | MAXIMUM ] DATABLOCKSIZE }

blockcompression

BLOCKCOMPRESSION = { AUTOTEMP | MANUAL | ALWAYS | NEVER | DEFAULT }
  [, BLOCKCOMPRESSIONALGORITHM = { ZLIB | ELZS_H | DEFAULT } ]
  [, BLOCKCOMPRESSIONLEVEL = { value | DEFAULT } ]

data_type_attribute

{ { UPPERCASE | UC } |
  [NOT] { CASESPECIFIC | CS } |
  FORMAT quotestring |
  TITLE quotestring |
  NAMED name |
  DEFAULT { number | USER | DATE | TIME | NULL } |
  WITH DEFAULT |
  CHARACTER SET server_character_set 
}

QITS_attribute

{ column_name data_type column_attribute [...] |
  column_constraint_attributes
}

column_attribute

{ data_type_attribute [...] |
  [NOT] NULL |
  compression_attributes |
  column_constraint_attributes |
  column_identity_attributes | 
}

column_constraint_attributes

[ CONSTRAINT name ]
  { { UNIQUE | PRIMARY KEY } ( column_name [,...] ) | CHECK (boolean_condition ) }

compression_attributes

COMPRESS [ { constant | NULL } | ( { constant | NULL } [,...] ) ]

column_identity_attributes

GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY [ ( identity_attribute [...] ) ]

identity_attribute

{ START WITH |
  INCREMENT BY |
  [NO] MINVALUE |
  [NO] MAXVALUE |
  [NO] CYCLE
}