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)A and B
E)A,B,and C

Question

Quizplus · Accepted Answer

When dropping a foreign key column from a table, the foreign key constraint from the table needs to be dropped first. Then, the foreign key column can be dropped from the table. It is not necessary to drop the primary key in the other table referenced by the referential integrity constraint. Therefore, steps A and B are the only necessary steps in the process.

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