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: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Thu, 20 Mar 2003 07:21:26 +0000
Message-ID: <b5bj3d$a1g$1@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 - 01:21:26 CST

Original text of this message

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