Which SQL statement correctly removes an index that is needed in a foreign key constraint?
A) DROP INDEX index_name;
B) ALTER TABLE table_name DROP CONSTRAINT constraint_name;
C) ALTER TABLE table_name DROP INDEX index_name;
D) ALTER TABLE table_name DROP FOREIGN KEY constraint_name;