Teradata
Syntax:
DROP INDEX index_name ON tablename; --or DROP INDEX(column1, column2, ..., columnN) ON tablename;
Example 1:
Dropping index named idx_dept from employee.
DROP INDEX idx_dept ON employee;
Example 2:
Dropping an index that is not named. The following drops the index on (dept_number, emp_number) columns in the employee table:
DROP INDEX (dept_number,emp_number) ON employee;
Oracle
Syntax:
DROP INDEX idx_dept;