What is the DROP DATABASE Statement in SQL ?
Answer: The SQL DROP DATABASE Statement is used to drop or delete an existing SQL database. Dropping of the database will drop all database objects(tables, views etc). The user should have admin privileges for deleting a database. The DROP Statement cannot be rollback.
Syntax
The Basic syntax of DROP DATABASE statement is as follows :
DROP DATABASE database_name;
Suppose we have a database named Employees:
DROP DATABASE Employees;
This will permanently delete the Employees database, including all the tables and data stored inside it.
Note: Be careful when using DROP DATABASE because the database and its contents are removed.
