When dropping a foreign key column from a table,which of the following steps is (are)included in the process? (The order of the steps listed below is not relevant,only the steps themselves. )
A)Drop the foreign key constraint from the table
B)Drop the foreign key column from the table
C)Drop the primary key in the other table referenced by the referential integrity constraint
D)Both A and B are correct

Question

Quizplus · Accepted Answer

When dropping a foreign key column from a table, we need to first drop the foreign key constraint associated with it from the table using the ALTER TABLE command, and then drop the foreign key column from the table using the ALTER TABLE command again. We do not need to drop the primary key in the other table referenced by the referential integrity constraint. Therefore, both A and B are correct steps to be taken.

When Dropping a Foreign Key Column from a Table,which of the Following