How to view relationships between tables??

Posted in 2005

Nuno Paquete — 20 Nov 2005 09:33:22 -0800 — source: Usenet: comp.databases.informix

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? Thanks in advance, Nuno Paquete

↪ replying to Nuno Paquete

Captain Pedantic — Sun, 20 Nov 2005 18:57:26 -0000 — source: Usenet: comp.databases.informix

"Nuno Paquete" <nunopaquete@lusocargo.pt> wrote in message news:1132508002.234416.87210@g43g2000cwa.googlegroups.com... > 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? Perhaps you could use a Ouija board and/or a sprit medium to contact the original designers to try to establish what they intended within the database design? Other than that, hard work, inference and inspiration would appear to be your best options.