Waylon Walker

πŸ’­ sql - How can I list the tables in a SQLite database file that...

Waylon Walker avatar
Author
1 min read
Copy this post
External Link
stackoverflow.com

I learned about the sqlite_master table from this stack overflow answer. This helps make a lot of sense to how sqlite works. The master table contains all the sqlite objects and the sql to create them.

The .tables, and .schema β€œhelper” functions don’t look into ATTACHed databases: they just query the SQLITE_MASTER table for the β€œmain” database. Consequently, if you used

sqlite3 database.db "SELECT * from sqlite_master;"

Note

This post is a thought. It’s a short note that I make about someone else’s content online #thoughts