Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2007
    Posts
    17

    Unanswered: Purging Multiple Tables using a reference table

    Hello All

    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)


    Thanks
    J

  2. #2
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •