Drop Table cannot be used to drop a Table referenced by ______constraint.
Drop Table cannot be used to drop a Table referenced by ______constraint.
(1) Primary key
(2) Sub key
(3) Super key
(4) Foreign key
Show answerHide answer
Correct answer: (C) (4)
Explanation
If you drop child table first, the foreign key will be dropped as well. If you attempt to drop percent table first you will get an "could not drop object "a" because it is referenced by a foreign key constraint error, Drop table can not be used to drop a table reference by a foreign key constraint. The referencing foreign key constraint or the referencing table must be dropped.