The SQL
DROP DATABASE statement is used to drop any existing database in SQL schema.
Syntax:
Basic syntax of DROP DATABASE statement is as follows:
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 has admin previledge before dropping any database. Once
a database is dropped, you can check it in the list of databases as
follows:
SQL> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| AMROOD |
| TUTORIALSPOINT |
| mysql |
| orig |
| test |
+--------------------+
6 rows in set (0.00 sec)
Thanks for sharing Informative post with us, keep update blog to get more Information to me.
ReplyDeleteartist platform in india || artist portfolio services in mumbai