DROPPING SECONDARY INDEX in Teradata

If you gave the name for an index, then it will be easy to drop it by giving it's name with the DROP syntax.

Syntax:
DROP INDEX index_name ON tablename;


Example:
Dropping index named ind_dept from tbl_employee.
DROP INDEX ind_dept ON tbl_employee;


You can also drop an index that is not named. The following drops the index on a multi-column key in the tbl_employee table:
DROP INDEX (department,emp_number) ON tbl_employee;