SQLite Guides

Tips and tricks on using SQLite.

How to Create a Table

How to Create a Temporary Table

How to Drop a Table

How to Rename a Table

How to Add a Column

How to Drop a Column

How to Rename a Column

How to Query JSON

Composite Primary Keys

How to view a table's CREATE TABLE statement