Re: Is constrtype=P primary key?

Jonas >>Can I recognize my primary keys in sysconstraint by constrtype=P? Yes. >>What does P and N in that field stand for otherwise? P stands for Primary key constraint and N for not-null constraint. >>(Which FM should I download and read?) Guide to SQL - reference, I think. Scan the other SQL manuals (use the find option in Acrobat for sysconstraints, for example). HTH Sujit Jonas Bergstr'm <jb300@hotmail.com> on 08/12/99 05:41:34 AM To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Is constrtype=P primary key? 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