Home  >  Forum  >  Database
Post New Query

sql plus-- how to drop all the tables at a time in a data base systems


joined on
October 07,2013
Asked on October 07,2013
how to drop all the tables from the server
joined on
March 14,2013
Replied on October 09,2013

Dropping all tables all together in database can be possible by two ways.

1. Suppose we a schema and tables are t1, t2 and t3.
drop it like 

drop table t1, t2, t3

2. Second approach is to delete the schema and re - create it.
The syntax of deleting schema is
drop database test;

joined on
October 10,2013
Replied on October 10,2013

Second option is better.

Write Answer








Copyright ©2017 concretepage.com, all rights reserved |Privacy Policy | Contact Us