Mass Drop of User tables
Posted: 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
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