Popular posts

This query will return the list of tables in the database :

SELECT * FROM sqlite_master WHERE type = 'table';

You can filter it down to a single row for an "exists" check :

SELECT * FROM sqlite_master WHERE type = 'table' AND tbl_name = 'xyz';