Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

6
  • 173
    Only "SELECT name FROM sqlite_master WHERE type='table'" works for me Commented Dec 15, 2015 at 13:28
  • 6
    SELECT name FROM my_db.sqlite_master WHERE type='table'; this does not work for me (for the attached DB) and it throws error as: no such table exist "my_db.sqlite_master" Commented Jul 27, 2016 at 7:16
  • what you meant by temporary tables? Are there any when I just opened SQLite db file? Commented May 7, 2017 at 13:20
  • Temporary tables are those created with CREATE TEMPORARY TABLE SQL commands. Their contents are dropped when the current database connection is closed, and they are never saved to a database file. Commented May 8, 2017 at 14:37
  • 2
    Under sqlite3 command mode and run ATTACH "some_file.db" AS my_db; It worked! Commented Dec 25, 2017 at 7:22