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


Database


Asked on October 07, 2013
how to drop all the tables from the server


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;




Replied on October 10, 2013
Second option is better.


Write Answer


Related Post










©2024 concretepage.com | Privacy Policy | Contact Us