Welcome to the Tweaking4All community forums!
When participating, please keep the Forum Rules in mind!
Topics for particular software or systems: Start your topic link with the name of the application or system.
For example “MacOS X – Your question“, or “MS Word – Your Tip or Trick“.
Please note that switching to another language when reading a post will not bring you to the same post, in Dutch, as there is no translation for that post!
A simple query gives you either '0' if the table does not exist, or >0 if the table(s) exist - you can even use a LIKE statement to look for multiple tables:
SELECT name FROM sqlite_master WHERE type="table" AND name="tablename";
Of course "tablename" should be the name of table you are looking for.
If the table exists, it will result in 1 row. If it doesn't then it results in zero rows.
Knowing that, we could also count (1 = table exists, 0 = table does not exist).
SELECT count(name) as Counted FROM sqlite_master WHERE type="table" AND name="tablename";
