drop tables

[oracler]

In our class projects, we screwed up the tables last time in Oracle8, so we tried to drop all of them and regenerate tables. However, because they are interconnected, we couldn't drop them one by one. Is there any command to drop all the tables in your space?

thanks.

 

[sem]

You may drop table by

drop table your_table cascade constraints;

To drop all tables you may loop through user_tables and issue drop commands using EXECUTE IMMEDIATE.