SQLite

Learning resources

Personal notes

From the sqlite shell:

.help 
.show
.exit
.database
.databases
.open path_to_example.db
.tables
.table '%es'
.schema table_name

The master table holds the key information about your database tables and it is called sqlite_master. To see its schema:

.schema sqlite_master

Back to top

Index