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 and flow from this site, held on your device and searchable with no connection. Free to install, no ads.
Get it free on the App Store