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

http://www.casestudio.com/enu/products.aspx > -----Original Message----- > From: Jean Sagi [SMTP:jeansagi@myrealbox.com] > Sent: Monday, November 28, 2005 12:05 AM > To: informix-list@iiug.org > Subject: [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 sending to informix-list