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
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.