Обсуждение: How can i drop a foreign key relation

Поиск
Список
Период
Сортировка

How can i drop a foreign key relation

От
"shreedhar"
Дата:
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

От
Stephan Szabo
Дата:
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.