SQL Server – How to Remove Foreign Key Constraint

databaseforeign-keyssql-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.

Try following

ALTER TABLE <TABLE_NAME> DROP CONSTRAINT <FOREIGN_KEY_NAME>

You can try

 sp_help [table_name]

to get all the foreign key constraints.

When you get the foreign key constraints on the table. Drop them by writing something like this:-

ALTER TABLE [dbo].[table_name] DROP CONSTRAINT [Foreign_FK]