Home » SQL & PL/SQL » SQL & PL/SQL » drop all tables (Oracle 9i)
drop all tables [message #281494] Sat, 17 November 2007 10:09 Go to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello All,


Can you please help me out in giving out the syntax for dropping all the tables(or any objects) in my schema.

I've seen the demodrop.sql script but that will help me in dropping only those tables that are there in the script.

And moreover I'm looking for sql syntax.

Help me out please.

Regards,

Raj
Re: drop all tables [message #281497 is a reply to message #281494] Sat, 17 November 2007 11:17 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Have you searched the forum?
One
Two

By
Vamsi
Re: drop all tables [message #281498 is a reply to message #281494] Sat, 17 November 2007 11:21 Go to previous message
BlackSwan
Messages: 25038
Registered: January 2009
Location: SoCal
Senior Member
It all depends & is not necessarily that simple.

DROP USER <MY_SCHEA> CASCADE
Previous Topic: calculate percent(toad oracle8.5)
Next Topic: Package Errors
Goto Forum:
  


Current Time: Mon Dec 05 14:44:04 CST 2016

Total time taken to generate the page: 0.05708 seconds