Word list
Code: SQL
SQL keywords across SELECT, JOIN, GROUP BY, window functions, DDL, transactions. Mostly uppercase — drills the shift key too.
- SELECT
- FROM
- WHERE
- INSERT
- INTO
- VALUES
- UPDATE
- SET
- DELETE
- CREATE
- TABLE
- ALTER
- DROP
- TRUNCATE
- INDEX
- VIEW
- DATABASE
- SCHEMA
- JOIN
- INNER
- LEFT
- RIGHT
- FULL
- OUTER
- CROSS
- ON
- USING
- UNION
- INTERSECT
- EXCEPT
- GROUP
- BY
- ORDER
- ASC
- DESC
- HAVING
- LIMIT
- OFFSET
- DISTINCT
- ALL
- AS
- AND
- OR
- NOT
- IN
- BETWEEN
- LIKE
- ILIKE
- IS
- NULL
- CASE
- WHEN
- THEN
- ELSE
- END
- WITH
- RECURSIVE
- COUNT(*)
- SUM(
- AVG(
- MIN(
- MAX(
- COALESCE(
- NULLIF(
- CAST(
- EXTRACT(
- NOW()
- CURRENT_DATE
- PRIMARY
- KEY
- FOREIGN
- REFERENCES
- UNIQUE
- CHECK
- DEFAULT
- CONSTRAINT
- CASCADE
- RESTRICT
- INTEGER
- BIGINT
- SMALLINT
- DECIMAL
- NUMERIC
- REAL
- FLOAT
- TEXT
- VARCHAR
- CHAR
- BOOLEAN
- DATE
- TIMESTAMP
- TIMESTAMPTZ
- INTERVAL
- JSON
- JSONB
- UUID
- SERIAL
- COMMIT
- ROLLBACK
- BEGIN
- TRANSACTION
- SAVEPOINT
- GRANT
- REVOKE
- EXPLAIN
- ANALYZE