CREATE TABLE Syntax ( Object File System Form) | VantageCloud Lake - CREATE TABLE Syntax (Object File System Table Form) - Teradata VantageCloud Lake

CREATE MULTISET TABLE [ database_name. | user_name. ] table_name,
  STORAGE = TD_OFSSTORAGE 
  [, RETENTIONDAYS = <retention_days> ]
  [ , MAP = map_name [COLOCATE USING colocation_name ] ]
  ( column_specification [,...] )
  [ ORDER BY (<column list> | <expression list>) | NO ORDER BY}​
  [UNIQUE] PRIMARY INDEX [index_name] ( index_column_name [,...] ) [ NO PRIMARY INDEX ]
  [ PARTITION BY COLUMN | NOT PARTITIONED ] [;]
<expression list> ::= [ <expression> [, <expression>]...])

column_specification

column_name data_type [ column_data_type_attribute ]

column_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 |
  [NOT] NULL |
  [NOT] AUTO COLUMN |
  compression_attribute |
  column_constraint_attribute
}

compression_attribute

{ NO COMPRESS |

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

  COMPRESS USING compress_UDF_name DECOMPRESS
    USING decompress_UDF_name
}

column_constraint_attribute

[ CONSTRAINT constraint_name ]
  CHECK ( boolean_condition ) references
  [ row_level_security_constraint_column_name [,...] ] CONSTRAINT

references

 REFERENCES [ WITH NO CHECK OPTION ] referenced_table_name
   [ ( referenced_column_name [,...] ) ]