Home » RDBMS Server » Server Administration » Re: Command to drop all tables???
Re: Command to drop all tables??? [message #372733] Tue, 06 March 2001 10:03
Plamen
Messages: 2
Registered: March 2001
Junior Member
write the following select statement, that will generate all drop table statements for this tablespace:

SELECT 'DROP TABLE ', table_name, ';' FROM all_tables WHERE owner='YOUR_USERNAME';

Report message to a moderator

Previous Topic: Object REFs
Next Topic: retriving particular rows in order
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 01:19:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.