To drop a foreign key column from a table,no preliminary steps are needed and we can simply use the ALTER TABLE DROP COLUMN statement.

Name: To drop a foreign key column from a table,no preliminary steps are needed and we can simply use the ALTER TABLE DROP COLUMN statement.
Brand: Quizplus
Rating: 4.9 (32 reviews)

Question

Quizplus · Accepted Answer

Before dropping a foreign key column, you must first drop the foreign key constraint using ALTER TABLE DROP FOREIGN KEY. Only after removing the constraint can you safely drop the column with ALTER TABLE DROP COLUMN.

To Drop a Foreign Key Column from a Table,no Preliminary