SQL DROP

DROP statement is used to erase an index or database or table.

DROP INDEX

DROP INDEX Syntax for MySQL

ALTER TABLE tableName DROP INDEX indexName

DROP INDEX Syntax for DB2 and ORACLE

DROP INDEX indexName

DROP INDEX Syntax for ACCESS

DROP INDEX indexName ON tableName

DROP INDEX Syntax for SQLSERVER

DROP INDEX tableName.indexName

DROP TABLE

DROP TABLE is used to erase a table

DROP TABLE tableName

DROP DATABASE

DROP DATABASE is used to delete a database permanently.

DROP DATABASE namebasededatos