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

Hi,

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.

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

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post