CREATE TABLE

SafeCreate tables

CREATE TABLE <name> (col type, ...);

Defines a table; constraints set up front decide data quality later. IF NOT EXISTS makes it rerunnable.

Examples

CREATE TABLE users (id INT PRIMARY KEY, email VARCHAR(255) NOT NULL UNIQUE);Table with constraints

Syntax

CREATE TABLE name (col TYPE [constraints], ..., PRIMARY KEY(col));

Before you run it

Creation only.

Related commands

ALTER TABLEAlter table structure
DESCRIBEDescribe a table
CREATE INDEXCreate an index

The same reference, with no signal at all

Every command on this site, held on your device. The app adds 632 more: 1,510 commands and 120 fix flows, searchable with no connection. Free to install, no ads (some content is a one-time purchase).

Get it free on the App Store