Re: Drop table in sql

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/09/19
Message-ID: <34234444.6B34@postoffice.worldnet.att.net>#1/1

If all the tables you want to drop belong to one user, use this statement:

DROP USER <user_name> CASCADE;

Do not try this with user SYS or SYSTEM !

Hope this helps.

Michael Serbanescu

---

Cuong Quyen Truong wrote:
>
> Does anyone know how to drop all the tables with one sql sttement.
Received on Fri Sep 19 1997 - 00:00:00 CDT