Is constrtype=P primary key?

Posted in 1999

Jonas Bergstr�m — Thu, 12 Aug 1999 12:41:34 CEST — source: Informix-list mailing list archive (1991-1998)

Hi newsgroup! Can I recognize my primary keys in sysconstraint by constrtype=P? What does P and N in that field stand for otherwise? (Which FM should I download and read?) Regards Jonas Bergstr'm Informix DBA (new, formal MSSQL DBA) Siemens Business Services AB Stockholm Sweden ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

↪ replying to Jonas Bergstr�m

Jing Liu — Thu, 12 Aug 1999 15:36:48 -0700 — source: Informix-list mailing list archive (1991-1998)

You can find the description of constrtype in Informix Guide to SQL: Reference values of constrtype in sysconstraints: 'C' = check constraint 'P' = primary key 'R' = referential 'U' = Unique 'N' = not null Jing