Supabase: The Complete Guide
SQL II: Tables, Types & Constraints
SQL II: Tables, Types & Constraints
CREATE TABLE, the data-type traps, keys, constraints, writes, upserts, and why a table you create in SQL is wide open until you close it.
0 / 7 concepts complete
13141516171819
CREATE TABLE & the DDL you write
Schema~100%
Data types & their traps
Schema~95%
Primary keys: identity vs uuid
Schema~90%
Constraints: NOT NULL, DEFAULT, CHECK, UNIQUE
Schema~90%
INSERT, UPDATE, DELETE & RETURNING
SQL~100%
ON CONFLICT & upsert
SQL~80%
RLS primer: open until you close it
Security~95%