SQL DROP Database

The SQL DROP DATABASE statement is used to delete an existing database. This operation removes the database and all of its tables, views, stored procedures, and other objects.
Syntax: DROP DATABASE database_name;

This command is irreversible, so be sure to back up any important data before performing this operation. Typically, only users with administrative privileges can execute this command.

Code Example


DROP DATABASE SchoolDB;
            

Output

Database "SchoolDB" deleted successfully.

The DROP DATABASE statement permanently removes the specified database. Be cautious when using this command, as it cannot be undone once executed.

Important Notes:
- Always ensure that a database is no longer in use and that any required data is backed up before executing a drop.
- Some RDBMS may require you to first disconnect users or active connections to the database before it can be dropped.