Re: How to view relationships between tables??

Nuno Paquete wrote: > Hi group, > > I'm developing an application that have to use an Informix database and > I don't have any documentation about relationship between tables. > The database has got a few hundreds of tables and now I need to know > the relationships between them. > I used "dbschema" command but I only get fields and indexes. > What do you suggest?? Is there any other way to do this? If foreign keys relationships have been set up, which dbschema would show you, then that might go some way to helping you. Otherwise you'll just have to hope the column and table names are self-documenting. Ben.