[Question]drop all tables owned by a user

From: anonymous <newbie_tw_at_yahoo.com.tw>
Date: 27 Jan 2005 01:48:43 -0800
Message-ID: <7be59b3a.0501270148.4e616f78@posting.google.com>

>Fuzzy Greybeard (Fuzzy.GreyBeard_at_Gmail.com)
>On Tue, 25 Jan 2005 19:49:55 -0800, anonymous wrote:

>> Is it possible to drop all tables by user who owns those tables in one
>> sqlstatement? for instance, I have a user who has A, B, C ... Z
>> tables.
>> Then I want to drop all those tables by sql statement. is it possible?
>> If yes, how?
>> I appreciate any suggestion, sincerely.

>Have you looked at "DROP USER lklkj CASCADE;"?

hi, Fuzzy:
It's useful and that's what I'm looking for. Thank you very much.; ) Received on Thu Jan 27 2005 - 03:48:43 CST