Re: Delete

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/07/09
Message-ID: <3967DC33.7BE2@yahoo.com>#1/1

SCIS-Student wrote:
>
> How can I delete all of the tables in my account without using DROP
> TABLE for each table?
>
> Thanks
>
> ZWA
Why not

spool blah.sql
select 'drop table '||table_name||' cascade constraints;' from user_tables;
@blah

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse

Received on Sun Jul 09 2000 - 00:00:00 CDT