RE: How to browse a database?
There is one free graphical tool in Informix site (www.informix.com)
named "Relational Object Manager" which you can browse all objects in
informix servers greater than version 7.1
Daniel.
}----------
}De: peter@prospect.anprod.csiro.au[SMTP:peter@prospect.anprod.csiro.au]
}Enviado: Martes 16 de Septiembre de 1997 08:02 PM
}Para: informix-list@rmy.emory.edu
}Asunto: Re: How to browse a database?
}
}
}In article <Pine.AMI.3.96.970911184618.130493504B-100000@aww.com> Rick
}O'Sullivan <rosully@aww.com> writes:
}>I'm a newby to Informix. When one has a databse with many tables, what
}>is the best way to discover the relationships and browse the data?
}
}1. Dump the schema (dbschema) and look at the PK-FK code, usually
}contained in a big block of ALTER TABLE statements.
}
}2. Get an ERA tool that can 'reverse-engineer' the schema. Look at
}www.embarcadero.com; they have a 30 day trial one that sort of works for
}Informix. That is, it *does* work and shows relationships but at least for
}SE 5.06, fields defined as Primary aren't picked up that way.
}
}Fair warning, though. If you have a lot of tables, you still end up with
}spaghetti if you select them all into a single diagram. I'm playing with
}150 tables at the moment. Messy.
}
}Peter Wiley
}
}