How to remove foreign key constraint in sql server?

sql-server database foreign-keys
Ammar Asjad picture Ammar Asjad · Sep 19, 2012 · Viewed 264.7k times · Source

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

Prasanna picture Prasanna · Sep 19, 2012

Try following

ALTER TABLE <TABLE_NAME> DROP CONSTRAINT <FOREIGN_KEY_NAME>

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

Related questions

The ALTER TABLE statement conflicted with the FOREIGN KEY constraint

I have a problem when trying to add a foreign key to my tblDomare table; what am I doing wrong here? CREATE TABLE tblDomare (PersNR VARCHAR (15) NOT NULL, fNamn VARCHAR (15) NOT NULL, eNamn VARCHAR (20) NOT NULL, Erfarenhet VARCHAR (5), PRIMARY KEY (…

Read More
Does the foreign keys automatically get updated as primary table is updated?

Above is my simple database design, just wanted to gain information about how things happen as I'm really new at database. Following are my questions: as I update wall_id in walls table, does the wall_id in wall_categories …

Read More
Reset identity seed after deleting records in SQL Server

I have inserted records into a SQL Server database table. The table had a primary key defined and the auto increment identity seed is set to “Yes”. This is done primarily because in SQL Azure, each table has to have …

Read More