I wish to drop all tables without rows.
How you can drop all empty tables in SQLite?
I have to do that on the cell phone (no spend there). On the Home windows Cell phone.
Tables could be dropped, whether they have data inside them once the command is performed. Dunno associated with a database that works otherwise. To ensure that means:
1) Getting a listing of tables -
SELECT name FROM sqlite_master WHERE type = 'table'
2) Iterate over that list, using COUNT(*) to find out if any rows exist inside a table:
SELECT COUNT(*) FROM ~table
3) When the number came back is under 1, perform DROP statement:
DROP TABLE ~table
SQLite does not have function or saved procedure support - you will need to do that out of your application.