Drop user with many tables

Posted by brucejin on 29-Mar-2011 10:58

When use SQL to drop user, I have to drop all tables under this user then the DROP USER will be successful.

Questions:

(1) Is there a command to drop a user even this user has tables?

(2) Is there a command to drop tables using a wild card? Like DROP TABLE mytable*;

Thanks!

This thread is closed