Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
DROPPING COLUMN AND UNREFERENCED IT AS A FOREIGN KEY
How can I drop a column? and how can I unreferenced a column as a foreign key.
1 answers ( 0 marked as helpful)
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
