How to remove foreign key constraint in sql server?

Question

I want to remove foreign key from another table so i can insert values of my choice.

I am new in databases so please tell me correct sql query to drop or remove foreign key value.

Answer 1

Try following

ALTER TABLE <TABLE_NAME> DROP CONSTRAINT <FOREIGN_KEY_NAME> 

Refer : http://www.w3schools.com/sql/sql_foreignkey.asp

Answer 2

Its wrong to do that in refer to referential integrity, because once its broken its not easy to turn it on again without having to go through the records and delete the ones which breaks the constraints.

Anyway the Syntax is as follows:

ALTER TABLE Tablename DROP CONSTRAINT ContName; 

See MSDN:

• Delete Primary Keys
• Delete Foreign Key Relationships