SQL DELETE DATABASE

You can easily remove or delete indexes, tables and databases with the DROP statement.

The DROP index statement is:

Used to delete index in the table

DROP INDEX SYNTAX for MS Access:

DROP INDEX SYNTAX for MS SQL Server:

DROP INDEX syntax for DB2/Oracle:

DROP INDEX syntax for MySQL:

DROP DATABASE Statement:

The drop database statement is used to delete a database.

Note:

We should always note that in RDBMS, database name should be unique.

We should always remember that DROP database command may be the cause of loss of all information so we should always be careful while doing this operation.