Search code examples
sql-serverdatabaseforeign-keys

How to remove foreign key constraint in sql server?

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.

Solution

  • Try following

    ALTER TABLE <TABLE_NAME> DROP CONSTRAINT <FOREIGN_KEY_NAME>

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