CREATE TABLE

Define a new table

Synopsis

CREATE TABLE statement

CREATETABLEIFNOTEXISTStable-namefield-definition,,table-constraint,table-constraint,

Parameters

IF NOT EXISTS

Do not throw an error if a table with the same name already exists.

table-name

The name of the table to be created.

Field definition

field-pathtype-namefield-constraint
table-name

The name of the table to be created.

Field constraint

PRIMARYKEYUNIQUENOTNULLDEFAULT(expr)exprCHECK(expr)

Table constraint

PRIMARYKEY(field-path)UNIQUEKEY(field-path)CHECK(expr)

Last modified November 9, 2021: Add CHECK (10b7e10)