Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sql script delete all tables
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