How to delete or alter a foriegn Key?

Question

I have used following codes
Alter table table_name drop foriegn key foriegn_keyname;
Alter table table_name drop key foriegn_keyname;
Alter table table_name drop column colum_name;
But none of these are working. It's giving some rename error;

Answer 1

use ALTER TABLE Table_name
DROP FOREIGN KEY;
you don't need to write foreign key name.

Answer 2

I have tried that also but its not working.