Search This Blog

Tuesday, August 25, 2015

Useful sqlite system queries


List tables and indexes in SQlite database:

SELECT * FROM sqlite_master


List columns for a table:

pragma table_info()

No comments: