How to remove contraint

From: Vernon Wu <vernonw(at)gatewaytech(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: How to remove contraint
Date: 2002-06-11 19:57:53
Message-ID: TNA8ZTTR962ZSR84WULFWUDAXS63987.3d065641@kimiko
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


I have been trying to remove a foreign key contraint from a table with any success. I had a look at the docuemnt, the
command should be something like

ALTER TABLE mytable DROP CONTRAINT contraiint

What the "contraint" shall be if the table has "Triggers: RI_ConstraintTrigger_16613"?

Thanks

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message kumar 2002-06-11 20:40:42 Timestamp problem
Previous Message Adam 2002-06-11 18:21:05 Select * (but exclude columns)