posted 15 years ago
Hi Members,
I have to delete a column from a table, which is a foreign_key. Also the column has some data with it. I need to drop the column along with the data.
Im using mysql 5.0.27.
Please share your views in this. How it shall be done.
I also tried using 'set foreign_key_checks = 0;' But im facing some exceptions:
Error: 150, error on rename.
Regards,
Prabhu.