SQLite - Delete everything from multiple tables

Question

The statement:

DELETE from users;

will delete everything from the table users. But how do I delete everything from three tables users, inactiveUsers, activeUsers

I tried this query in Firefox SQLite manager :

DELETE from users, inactiveUsers, activeUsers;

and it gives the error message -

SQLiteManager: Likely SQL syntax error: DELETE from users, inactiveUsers, activeUsers; [ near ",": syntax error ] Exception Name: NS_ERROR_FAILURE Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]

I don't think you can execute DML on multiple tables in one statement. — Scotch

cha cha · Accepted Answer · 2013-02-26T01:14:30

can't you run three queries?

DELETE from users;
DELETE from inactiveUsers;
DELETE from activeUsers;

If it is a huge problem for you, then you need to consider creating foreign keys.

SQLite - Delete everything from multiple tables

2 Answers