There are tables: a, b, c, d.
All tables have the same
FK = IDXXX .
Is it possible to delete records from all tables using this key with one query?
Something like this:
DELETE FROM a,b,c,d WHERE IDXXX = 'YYYY';
If you need delete integrity, wrap a delete from all tables in a single transaction, rolling back the entire transaction in the event of a problem with a delete from any table.