SQLite Function Reference

Browse SQLite function references by category: core, string, date and time, math, JSON, aggregate, window, and system functions.

For practical guidance on storing JSON as text or SQLite JSONB, read SQLite JSONB: When and How to Use It.

To run a query without connecting to a server, use the temporary SQLite SQL playground. To reformat SQLite SQL without running it, use the browser-based SQL formatter; SQLite is selected automatically.

For CLI and SQL table-listing commands across SQLite and other database systems, see the cross-database table-listing guide.

For commands to list only views across SQLite and other SQL databases, see List Views in SQL.

To distinguish attached SQLite databases from server database catalogs in other engines, see List Databases in SQL.

To inspect table indexes, their key columns, and expression definitions, see the SQLite index metadata guide.