If foreign key exists, drop it

Question

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.

which database management system are you using? oracle, mssql, postgre, etc.? — Gambrinus, Feb 08 '12 at 15:42
There is no standardized way to do that, but each DBMS has its own - please answer Gambrinus's question. — Branko Dimitrijevic, Feb 08 '12 at 15:53

Iridio · Accepted Answer · 2013-01-25T11:25:38.913

9

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

edited Jan 25 '13 at 11:25

answered Feb 08 '12 at 15:43

Iridio

9,213
4
49
71

If foreign key exists, drop it

1 Answers1