To drop a column that is used as a foreign key, first:

• drop the primary key.
• drop the table containing the foreign key..
• drop the foreign key constraint.
• All of the above must be done.