Primary key

Posted in 1999

GIRISH MOHAN KADIVAL — Tue, 18 May 1999 15:07:09 +0530 (IST) — source: Informix-list mailing list archive (1991-1998)

Hello , I would like to know how to find out the primary key of a table using a script. I want to find it out for about 175 tables and then compare their primary keys for duplicates using a script Thank you . bhaskar

↪ replying to GIRISH MOHAN KADIVAL

donfranke@my-dejanews.com — Wed, 19 May 1999 17:32:17 GMT — source: Informix-list mailing list archive (1991-1998)

You can export the db schema (dbschema > schema1.txt) and do a grep on the file to locate primary keys. Or you can query the system tables; refer to manual for which system table maintains PK info. In article <7hrdaf$cl5$1@news.xmission.com>, GIRISH MOHAN KADIVAL <girish.kadival@tatainfotech.com> wrote: > > Hello , > I would like to know how to find out the primary key > of a table using a script. > I want to find it out for about 175 tables > and then compare their primary keys for duplicates > using a script > Thank you . > bhaskar > > --== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.---