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