Deleting Primary Keys

Posted in 2003

Summary

Don Bryant asked how to drop a primary key. Jonathan Leffler answered ALTER TABLE x DROP CONSTRAINT y if it was named. Daniel Morgan then offered ALTER TABLE ... DROP PRIMARY KEY for an unknown name, but admitted it was Oracle SQL posted by mistake.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: General Discussion

Don Bryant — Sat, 20 Sep 2003 01:01:22 GMT — source: Usenet: comp.databases.informix

Can describe how to drop a primary key from a table? Thanks, Don Bryant

↪ replying to Don Bryant

Jonathan Leffler — Sat, 20 Sep 2003 03:55:19 GMT — source: Usenet: comp.databases.informix

Don Bryant wrote: > Can describe how to drop a primary key from a table? If you gave it a name, then: ALTER TABLE x DROP CONSTRAINT y; -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

↪ replying to Jonathan Leffler

Daniel Morgan — Sat, 20 Sep 2003 00:06:01 -0700 — source: Usenet: comp.databases.informix

Jonathan Leffler wrote: > Don Bryant wrote: > >> Can describe how to drop a primary key from a table? > > > If you gave it a name, then: > > ALTER TABLE x DROP CONSTRAINT y;> And if you don't know the constraint's name .... ALTER TABLE <table_name> DROP PRIMARY KEY; -- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply)

↪ replying to Jonathan Leffler

Daniel Morgan — Sat, 20 Sep 2003 00:06:50 -0700 — source: Usenet: comp.databases.informix

Jonathan Leffler wrote: > Don Bryant wrote: > >> Can describe how to drop a primary key from a table? > > > If you gave it a name, then: > > ALTER TABLE x DROP CONSTRAINT y;> Darn ... I'm bouncing back and forth between too many usenet groups, it is after midnight and I lost my place. Sorry for the Oracle SQL. -- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply)