DROP or DELETE
Database
The
SQL DROP DATABASE statement is used to drop an existing database in SQL schema.
Syntax:
DROP
DATABASE DatabaseName;
Always
database name should be unique within the RDBMS.
Example:
If you
want to delete an existing database <testdb>, then DROP DATABASE
statement would be as follows:
SQL>
DROP DATABASE testdb;
NOTE:
Be careful before using this operation because by deleting an existing database
would result in loss of complete information stored in the database.
Make
sure you have admin privilege before dropping any database. Once a database is
dropped, you can check it.
SQL>
in the list of databases as follows:
SHOW
DATABASES;
+---------------------------+
|
Database |
+---------------------------+
|
information_schema |
| demo
|
|
mysql |
|
performance_schema |
| test
|
+---------------------------+
5 rows
in set (0.00 sec)
0 Comments