What is SQL DROP INDEX Statement Syntax and Examples

The DROP INDEX Statement
The DROP INDEX statement is used to delete an index in a 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

THE DROP TABLE STATEMENT
THE DROP TABLE STATEMENT IS USED TO DELETE A TABLE.
DROP TABLE table_name