Mass Drop of User tables

IBM's flagship relational database management system

Mass Drop of User tables

Postby jaggz » Tue Feb 21, 2012 4:04 pm


Is there a command to drop all the tables created by one user ? I Believe we can get the list from the SYSIBM.SYSTABLES and generate a DROP command to remove all the tables from the Tablespace, but Just looking for a command to perform a mass drop of tables created by one user.

Could anyone please assist me on the above.

User avatar
Posts: 356
Joined: Fri Jul 23, 2010 8:51 pm
Has thanked: 8 times
Been thanked: 3 times

Re: Mass Drop of User tables


Return to DB2


  • Related topics
    Last post