Thread: drop foreign key

drop foreign key

From
"Madhavi"
Date:
Can anybody please tell me how to drop a foreign key associated with a table
in postgres7.2.3? Please give me the syntax and the query.

Thanx
Madhavi



Re: drop foreign key

From
Stephan Szabo
Date:
On Fri, 20 Dec 2002, Madhavi wrote:

> Can anybody please tell me how to drop a foreign key associated with a table
> in postgres7.2.3? Please give me the syntax and the query.

In 7.2.3 you'll need to find the three triggers associated with the key
and drop those with drop trigger (doublequoting the name because it's of
mixed case).  Techdocs has some information on foreign keys that will
probably be useful.