SQL Quick Reference

The eSQL implements most of the standard SQL language as defined in SQL-92. This document is a quick overview of the SQL syntax for eSQL.

1. SQL Overview

   • SQL Syntax
   
   

2. SQL Elements

   • Comments
   • Operators
   • Expressions
   • Functions
   
   

3. SQL Statements

   • SQL Commands
     • CREATE
       • CREATE INDEX
       • CREATE TABLE
       • CREATE TRIGGER
       • CREATE VIEW
     • DELETE
     • DROP
       • DROP INDEX
       • DROP TABLE
       • DROP TRIGGER
       • DROP VIEW
     • INSERT
     • REPLACE
     • SELECT
     • UPDATE
   • Transactions
     • BEGIN TRANSACTION
     • COMMIT TRANSACTION
     • END TRANSACTION
     • ROLLBACK TRANSACTION
   • SQL Clauses
     • ON CONFLICT clause
   • Special Operations
     • ATTACH DATABASE
     • DETACH DATABASE
     • COPY
     • EXPLAIN
     • PRAGMA
     • VACUUM
   
   

4. Keywords

   • eSQL Keywords