SQL DROP DATABASE Statement - shahzade baujiti

Breaking

Sunday, April 21, 2019

SQL DROP DATABASE Statement

Toggle navigation
TUTORIAL HOME
SQL DROP DATABASE  Statement
❮ Previous Next ❯
The SQL DROP DATABASE Statement
The DROP DATABASE statement is used to drop an existing SQL database.

Syntax
DROP DATABASE databasename;
Note: 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":

Example
DROP DATABASE testDB;
Tip: 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;


❮ Previous Next ❯

No comments:

Post a Comment