Thread: CONSTRAINT

CONSTRAINT

From
Marcelo Pereira
Date:
Hello All,

Is there any way I could drop a CONSTRAINT (foreign key) ?

Regards,

--
Marcelo Pereira


Re: CONSTRAINT

From
Stephan Szabo
Date:
On Wed, 27 Feb 2002, Marcelo Pereira wrote:

> Hello All,
>
> Is there any way I could drop a CONSTRAINT (foreign key) ?

In 7.2 you should be able to use ALTER TABLE DROP CONSTRAINT
to drop the constraint by the name you gave it.  Otherwise
you can remove the triggers that implement the constraint.  There's
more info on techdocs.postgresql.org that go into the details
of the triggers which will let you find them.