CREATE TABLE

Grammar syntax

CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] TABLE [ IF NOT EXISTS ]
table_name
[(
  column | constraint_definition[, ...]
)]
[DEFAULT COLLATE collate_specification]
[PARTITION BY partition_expression]
[CLUSTER BY clustering_column_list]
[OPTIONS(table_option_list)]
[AS query_statement]

Click here to go to the BigQuery specification for this syntax.

Navigate to the following pages to get more details about the translation spec for CREATE TABLE syntax.

TABLE SCOPE

• OR REPLACE

• TEMP/TEMPORARY

• IF NOT EXISTS

COLUMN DEFINITION

• PRIMARY KEY NOT ENFORCED

• REFERENCES NOT ENFORCED

• DEFAULT CONSTRAINT

• NOT NULL

• OPTIONS CLAUSE

• STRING COLLATE

CONSTRAINT DEFINITION

• PRIMARY KEY TABLE CONSTRAINT

• FOREIGN KEY TABLE CONSTRAINT

TABLE OPTIONS

• DEFAULT COLLATE

• PARTITION BY

• CLUSTER BY

• OPTIONS CLAUSE

• AS query_statement