DROPPING COLUMN AND UNREFERENCED IT AS A FOREIGN KEY

Hi Abayomi-Rufai!
Thanks for reaching out.

To drop a column in MySQL:

ALTER TABLE table_name DROP COLUMN column_name;

To remove a foreign key reference from a column in MySQL:

ALTER TABLE table_name DROP FOREIGN KEY constraint_name;

Hope this helps.
Best,
Tsvetelin