Drop Database

Drop Database

If database created is wrong by any chance or we do not want it any more, then we can delete the database using DROP command. But dropping a database will delete all its objects. Hence we need to be extra cautious while deleting a database.

DROP DATABASE library;

Above query will drop the database whose name is “library”. It will also delete all the tables, views, constraints, indexes, packages, procedures, functions etc from the database.

Translate ยป