SQL Language Understood By SQLite

Page 21 of 41
[prev] [next]

Supported Features

  • INSERT, DELETE, UPDATE, and SELECT
  • Subqueries
  • Tables, indices, triggers, and views
  • BEGIN, ROLLBACK, COMMIT
  • INNER JOIN, LEFT OUTER JOIN, NATURAL JOIN
  • UNION, UNION ALL, INTERSECT, EXCEPT
  • UNIQUE and NOT NULL constraints

Features Not Supported

  • CHECK constraints (parsed but not enforced)
  • Correlated Subqueries
  • Foreign Keys (parsed but not enforced)
  • ALTER TABLE
  • Some details of TRIGGER are omitted
  • RIGHT and FULL OUTER JOIN
  • Writing to VIEWs
  • GRANT and REVOKE