I have a sqlite database with 10 tables, each table has a unique ID column.
Then if for example I want to delete ID 200, what I want is to delete the 10 rows that are distributed in the 10 tables.
How can I do this without using ON DELETE CASCADE? (also I think it is not possible in sqlite).
The idea I have now is to do it manually one at a time but then the code becomes database specific and not reusable.