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 index_name ON table_name  

DROP INDEX SYNTAX for MS SQL Server:

DROP INDEX table_name.index_name  

DROP INDEX syntax for DB2/Oracle:

DROP INDEX index_name   

DROP INDEX syntax for MySQL:

ALTER TABLE table_name DROP INDEX index_name  

DROP DATABASE Statement:

The drop database statement is used to delete a database.

DROP DATABASE database_name  

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.