SQL DROP DATABASE Statement
The SQL DROP DATABASE Statement
The DROP DATABASE
statement is used to drop an existing SQL database.
SQL
DROP DATABASE databasename;
Important:
Be careful before dropping a database. Deleting a database will result in loss of complete information stored in the database!
DROP DATABASE Example
The following SQL statement drops the existing database “testDB”:
SQL
DROP DATABASE testDB;
Important:
Make sure you have admin privilege before dropping any database. Once a database is dropped, you can check it in the list of databases with the following SQL command: SHOW DATABASES
;
Feedback
Submit and view feedback