How to query tables' name in a empty database in sqlite.
-
I met problem, I want to show tables' name after I open a sqlite database, the faq in sqlite said that every database file has a table which's name sqlite_master. but the new database file is zero length file, I'm sure it has no sqlite_master. I just want to ask, in this situation, what I can do.
-
Hi,
If the file size is zero, it probably means it's empty so there's nothing to query about.
To ensure you have something in it (or not) you can use the sqlite3 command line application to edit the database
