Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: sql script delete all tables

Re: sql script delete all tables

From: Alan <alan_at_erols.com>
Date: Thu, 20 Mar 2003 15:21:31 -0500
Message-ID: <b5d7s9$28g93g$1@ID-114862.news.dfncis.de>


OR,

SELECT 'drop table '||tname||' from tab ; ' ;

Then copy and paste...

"Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message news:b5bj3d$a1g$1_at_ctb-nnrp2.saix.net...
> teen wrote:
>
> > How would I drop all tables created by me?
> >
> > I think there is a thing like user_tables or something? Anyone got any
> > idea?
>
> Try:
> SELECT
> 'drop table '||table_name||';'
> FROM user_tables
>
> Then copy and paste the output to SQL*Plus' command line.
>
>
> --
> Billy
Received on Thu Mar 20 2003 - 14:21:31 CST

Original text of this message

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