17.05 - CREATE TABLE構文(キュー テーブル形式) - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQLデータ定義言語 構文規則および例

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
2021年1月
Content Type
プログラミング リファレンス
Publication ID
B035-1144-175K-JPN
Language
日本語 (日本)
{ 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
}