Drop foreign key constratint and update the table

Give thought to Abhinav's advice - but if you go ahead this should do it:

ALTER TABLE tbl_name DROP FOREIGN KEY fk_symbol;

Here's an actual example that I have used:

ALTER TABLE VendaTic.RoleMaster DROP FOREIGN KEY Feature_Code;

Hello Dear,

What ever you are asking that is not possible. According to you the employee table is associated with another table by a foreign key. If you don't want another table reocord then do the following steps

1. right Click on the employee table and select modify. Then table will open with its column and datatypes. selct the column which is the foreign key.
2.Right click on that column and select relaionship.
3.One window will open where you select insert and update specification and selct the update rule then select no action from the dropdown.
4. Now your table will allow you to update.

Hope this will help you. If not then query again.

Thanks a lot guys for replying. Your replies are really helpfull, for everyone, if you are struck in such condition, never try the approach i followed that is droping the foreign key and then updating the table and then adding the foreign keys, it will mess up the structure and will make your database unstable.
Whatever everyone replied, thats the right approach but for me its still little chaotic as I can't modify the table because of some restrictions.
Is there any other way of doing the same without modifying the table to make it cascade.