head.daveops.net

Snippets for yer computer needs

SQLite

Show all tables

.tables

Show table schema —————–


 .schema tablename

See if table exists ——————-


 SELECT name 
 FROM sqlite_master
 WHERE type='table'

Export tables ————-

sqlite3 my.db .dump

Datatypes