Welcome to Westonci.ca, the place where your questions find answers from a community of knowledgeable experts. Get detailed and accurate answers to your questions from a dedicated community of experts on our Q&A platform. Get immediate and reliable solutions to your questions from a community of experienced professionals on our platform.

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;