SQL · Schema and constraints

create table

Defines a table and its columns, types and constraints.

sqlRunnable example sql course

Syntax

create table name (…);

Example

Open in the lab

CREATE TABLE courses (
  id INTEGER PRIMARY KEY,
  slug TEXT NOT NULL UNIQUE,
  title TEXT NOT NULL
);
SELECT name FROM sqlite_master WHERE type = 'table' AND name = 'courses';

Learn this in the course

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.

Open the course

create table

Example

More in this group

Learn this in the course