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