Page 1 of 1

Mass Drop of User tables

PostPosted: Tue Feb 21, 2012 4:04 pm
by jaggz
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