If foreign key exists, drop it

sql foreign-keys exists sql-drop
Tavousi picture Tavousi · Feb 8, 2012 · Viewed 9.4k times · Source

I have a table that has a foreign key relation with another table.

I want to check that if this relation exists, drop it.

How to I write this query.

Thanks.

Answer

Iridio picture Iridio · Feb 8, 2012

If you are using SQL Server, this should works

if exists (select 1 from sys.objects where object_id = OBJECT_ID(N'[FKName]') AND parent_object_id = OBJECT_ID('TableName'))
  alter table TableName drop constraint FKName

Related questions

INSERT statement conflicted with the FOREIGN KEY constraint - SQL Server

I am getting the following error. Could you please help me? Msg 547, Level 16, State 0, Line 1 The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Sup_Item_Sup_Item_Cat". The conflict occurred in database "dev_bo", table "dbo.Sup_…

Read More
MySQL Cannot Add Foreign Key Constraint

So I'm trying to add Foreign Key constraints to my database as a project requirement and it worked the first time or two on different tables, but I have two tables on which I get an error when trying to …

Read More
How to select rows with no matching entry in another table?

I'm doing some maintenance work on a database application and I've discovered that, joy of joys, even though values from one table are being used in the style of foreign keys, there's no foreign key constraints on the tables. I'm …

Read More