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:

  FROM ~table

3) When the number came back is under 1, perform DROP statement:


SQLite does not have function or saved procedure support - you will need to do that out of your application.