Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sql script delete all tables
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.
-- BillyReceived on Thu Mar 20 2003 - 01:21:26 CST