RE: How to view relationships between tables??

Posted in 2005

Chafik, Basim — Mon, 21 Nov 2005 09:11:26 -0500 — source: Usenet: comp.databases.informix

Nuno, You can use Visio, Visio has functionality to poke a database and draw a diagram for your database schema including tables, columns, indexes, foreign keys and relation between tables. You can save that As HTML or any type of doc you want. I used it before, it worked as intended. If you have Crystal report that will also do it. Basim Chafik Senior Systems Analyst IBM Certified Advanced Technical Expert (CATE) 1.800.688.4895 basim.chafik@plx.com plexus (Division of BancTec) -----Original Message----- From: Nuno Paquete [mailto:nunopaquete@lusocargo.pt] Sent: Sunday, November 20, 2005 12:33 PM To: informix-list@iiug.org Subject: How to view relationships between tables?? 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 sending to informix-list