From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | tibor <tiborh(at)mail(dot)datanet(dot)hu>, PostreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How can I delete a primary or foreign key? |
Date: | 2004-02-20 17:08:22 |
Message-ID: | 200402201708.22599.dev@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Friday 20 February 2004 16:04, tibor wrote:
> I forgot to mention that I have tried numerous variations.
> The one quoted in the original mail was from "The Complete Reference"
Which book is this?
Look in the SQL Command reference - ALTER TALBLE
> series. I've also tried the one that the \h command suggests:
>
> ALTER TABLE PARENTS DROP CONSTRAINT FOREIGN KEY (TYPE) CASCADE;
The \h says the same as the manuals:
ALTER TABLE [ ONLY ] table [ * ]
DROP CONSTRAINT constraint_name [ RESTRICT | CASCADE ]
If you have a table called "mytab" and a foreign-key constraint called
"myfkey" then you would use
ALTER TABLE mytab DROP CONSTRAINT myfkey;
If your constaint has a generated name like $1 then you'll want to quote it
"$1"
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Csaba Nagy | 2004-02-20 17:18:21 | Re: PHP + Postgres: More than 1000 postmasters produce |
Previous Message | tibor | 2004-02-20 17:06:44 | Re: How can I delete a primary or foreign key? |