To drop a primary key column from a table the primary key constraint must first be dropped,but this does not require that related foreign keys based on the column be dropped.

Question

Quizplus · Accepted Answer

When a primary key constraint is dropped, any foreign key constraints in other tables that reference the primary key must either be dropped or modified to reference a different key, as they depend on the primary key to enforce referential integrity.

To Drop a Primary Key Column from a Table the Primary