Alter Table Drop Index Syntax

The SQL syntax for ALTER TABLE Dop Index is
ALTER TABLE "table_name"
DROP INDEX " INDEX_NAME "
Let's look at the example. Assuming our starting point is the "customer" table created in the CREATE TABLEsection:
Table customer

Column Name	Data Type
First_Name	char(50)
Last_Name	char(50)
Address	char(50)
City	char(50)
Country	char(25)
Birth_Date	date

Assume we want to drop the index created in the ALTER TABLE ADD INDEX section. To do this, we type in the following:
ALTER table customer DOP INDEX IDX_COUNTRY;
Please note that using ALTER TABLE to drop an index is not supported in Oracle or SQL Server.