CREATE TABLE

Creates a new table in the database.

Syntax

sql

CREATE TABLE table (col1 type1, col2 type2, ...);

Example

sql

CREATE TABLE IF NOT EXISTS users (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  email TEXT UNIQUE NOT NULL,
  name TEXT NOT NULL,
  created_at TIMESTAMPTZ DEFAULT NOW()
);