SQL CommandsΒΆ DQL Syntax SELECT WITH JOIN WHERE GROUP BY CASE ORDER BY Window Functions EXPLAIN Operators DDL CREATE CREATE SCHEMA TEMPLATE CREATE DATABASE CREATE SCHEMA CREATE TABLE CREATE TYPE CREATE INDEX CREATE FUNCTION CREATE TEMPORARY FUNCTION DROP DROP SCHEMA TEMPLATE DROP DATABASE DROP SCHEMA DROP TEMPORARY FUNCTION DML INSERT Syntax Parameters Examples UPDATE Syntax Parameters Examples DELETE Syntax Parameters Examples COPY Syntax Parameters Examples