Unanswered: Purging Multiple Tables using a reference table
I was wondering if this is even possible:
I have created a reference table in the db that is a list of around 300 tables, I would like to delete the rows within all of these 300 tables. Is there a way to delete the entries on these tables by somehow using the reference table i created as opposed to running 300 delete statements?
It would nice if you could throw a select into the delete statement like the eg below:
DELETE FROM (SELECT refTable FROM tableList WHERE purgeYn = 1)