Advanced Schema

Column Constraints

OmniQL supports three column constraints using colon syntax:

:CREATE TABLE User WITH
  id:AUTO,
  email:STRING:NOTNULL:UNIQUE,
  name:STRING:NOTNULL

Chain multiple constraints with colons:

:CREATE TABLE Product WITH
  id:AUTO,
  sku:STRING:NOTNULL:UNIQUE,
  name:STRING:NOTNULL,
  price:DECIMAL

Database	Output
PostgreSQL	`CREATE TABLE products (id SERIAL PRIMARY KEY, sku VARCHAR NOT NULL UNIQUE, name VARCHAR NOT NULL, price DECIMAL)`
MySQL	`CREATE TABLE products (id INT AUTO_INCREMENT PRIMARY KEY, sku VARCHAR(255) NOT NULL UNIQUE, name VARCHAR(255) NOT NULL, price DECIMAL)`

For advanced features like sequences, custom types, triggers, and stored procedures, see database-specific documentation:

Not supported in OmniQL (use native SQL):