Re: how to retrieve primary and foreign key

> > > Hi, > > I am trying to retrieve the primary or foreign keys from > SYSCOLUMNS, SYSCONSTRAINTS etc, but i did not find any > connection between those two tables. > > can somebody give me any suggestion or hints to do that? > > regards > > liuhuiti@iscs.nus.sg > > Check out the Informix SQL manual chapter 2. Then go to mathcs.emoru.edu and get a copy of dbdiff2 it reads these structures and provides an example of how to do so. cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@hpbs3645.boi.hp.com _____________________________________________________________________________ Lysdexics Untie! _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________