Database Fundamentals — Question 70

Which statement should you use to remove a foreign key?

Answer options

• A. ALTER TABLE
• B. DELETE TABLE
• C. DELETE FOREIGN KEY
• D. ALTER FOREIGN KEY

Correct answer: A

Explanation

The correct answer is A, 'ALTER TABLE', as this command is used to modify the structure of a database table, including removing foreign key constraints. Options B and C are incorrect because 'DELETE TABLE' is not a valid SQL command for this purpose, and 'DELETE FOREIGN KEY' does not exist as a command. Option D is also incorrect as 'ALTER FOREIGN KEY' is not a recognized SQL statement.