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.