Re: [Question]drop all tables owned by a user

From: Fuzzy Greybeard <Fuzzy.GreyBeard_at_Gmail.com>
Date: Wed, 26 Jan 2005 04:09:45 GMT
Message-Id: <pan.2005.01.26.04.09.46.48000@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;"? Received on Tue Jan 25 2005 - 22:09:45 CST

This message: [ Message body ]
Next message: Alan: "Re: [Question]drop all tables owned by a user"
Previous message: anonymous: "[Question]drop all tables owned by a user"
In reply to: anonymous: "[Question]drop all tables owned by a user"
Next in thread: Alan: "Re: [Question]drop all tables owned by a user"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US