Information on Primary Keys, Indexes

Posted in 2006

Myjish — 15 May 2006 14:33:30 -0700 — source: Usenet: comp.databases.informix

Hi, How to get information on all primary keys, unique keys, indexes? Please advise. Regards Jignesh

↪ replying to Myjish

VG — 15 May 2006 14:52:28 -0700 — source: Usenet: comp.databases.informix

Run queries against the sysindexes table to get appropriate information with the appropriate tabid. tabid for a table can be obtained from systables. VG.

↪ replying to Myjish

glericu — 16 May 2006 02:09:58 -0700 — source: Usenet: comp.databases.informix

hello! for all tables the best method is dbschema -d <database> for a specified table: echo info indexes for <table>|dbaccess <database> regards glenn Myjish schrieb: > Hi, > > How to get information on all primary keys, unique keys, indexes? > > Please advise. > > Regards > Jignesh