Thread: How can i drop a foreign key relation

How can i drop a foreign key relation

From
"shreedhar"
Date:
Hi all,
 
How can i drop a foreign key relation. In my database I gave reverse relation ships which i should alter.
 
thanks alot,
 
with best regards,
baskar

Re: How can i drop a foreign key relation

From
Stephan Szabo
Date:
On Fri, 24 May 2002, shreedhar wrote:

> How can i drop a foreign key relation. In my database I gave reverse
> relation ships which i should alter.

You'll need to drop the three triggers that are created by the
foreign key constraint.  If you go to techdocs.postgresql.org there
are some pages on the foreign key constraints that should give more
info.