[Fwd: RE: How to view relationships between tables??]

Case Studio 2 ?? J. -------- Mensaje original -------- Asunto: RE: How to view relationships between tables?? Fecha: Thu, 24 Nov 2005 10:53:19 +0100 De: Gestsdottir, Kristin <k.gestsdottir@geos.com> Para: 'Nuno Paquete' <nunopaquete@lusocargo.pt>, informix-list@iiug.org Hi Nuno There is a cheaper alternative available called Case Studio 2. The reverse engineering for Informix is very fast. I think is good enough. My experience with Visio is that it is not at all happy with all types of Informix objects and that the database diagrams are more of an add-on and therefore not as robust as the rest of the application.. Kristmn > -----Original Message----- > From: Chafik, Basim [SMTP:Basim.Chafik@BancTec.ca] > Sent: Monday, November 21, 2005 2:11 PM > To: 'Nuno Paquete'; informix-list@iiug.org > Subject: RE: How to view relationships between tables?? > > 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 sending to informix-list sending to informix-list