PK on superstores_demo.non_us_location

Posted in 2003

Topics: Versions, Editions & End-of-Life

dom — 22 May 2003 01:42:03 -0700 — source: Usenet: comp.databases.informix

Hi all, I'm trying to define a primary key on IDS 9.3/9.4 demo database superstores_demo on tables us_location and non_us_location on their SERIAL columns. The engine errors & reports that the tables already have a primary key defined, but I can't see it in the system tables, neither does ServerStudio report these keys' existence. Can anybody explain this, please? Many thanks, dm.

↪ replying to dom

John Carlson — Thu, 22 May 2003 09:35:01 -0400 — source: Usenet: comp.databases.informix

On 22 May 2003 01:42:03 -0700, dominic.morris@eidosnet.co.uk (dom) wrote: What does dbschema say? >Hi all, > >I'm trying to define a primary key on IDS 9.3/9.4 demo database >superstores_demo on tables us_location and non_us_location on their >SERIAL columns. > >The engine errors & reports that the tables already have a primary key >defined, but I can't see it in the system tables, neither does >ServerStudio report these keys' existence. > >Can anybody explain this, please? > >Many thanks, >dm.

Related threads

Glossary

IDS (Informix Dynamic Server)