Home » RDBMS Server » Server Administration » Re: Command to drop all tables???
Re: Command to drop all tables??? [message #371137] Tue, 05 September 2000 14:35 Go to next message
Messages: 2
Registered: September 2000
Junior Member
Thank you
Re: Command to drop all tables??? [message #371153 is a reply to message #371137] Thu, 07 September 2000 14:06 Go to previous message
Salman Khan
Messages: 51
Registered: September 2000
There is no command to drop all the tables at once. But you can create your sql statments and drop all the tables. for example

Select 'Drop Table '||tname||';' from tab

spool the above statement output and run it.

Salman Khan
Previous Topic: 3~5 seconds to connect to oracle
Next Topic: SQL Output printing on HP Laser Jet printer (4000 N Seris)...
Goto Forum:

Current Time: Fri Sep 29 18:08:31 CDT 2023