Re: [?] Print table columns with relation to other tables?

In article <DB6A5u.n0x@twg.bc.ca>, bill@twg.bc.ca wrote: > >I need to teach some people how to use SQL and Ace in their >application. Before doing this I need to become familiar with >their application tables, especially those fields (columns) that >have a referential relationship to fields in other tables. I >will be needing to do join queries and would like to have these >field relationships readily apparent. > >Is there a way, in Informix SQL 4.00 or 4GL, to produce a report >of all the tables in a database which also shows the links >between the referential fields? I am hoping I don't have to >print out each tabl individually and manually inspect them for >relationships to each other. > >Thanks. >-- >Bill Irwin - The Westrheim Group - Vancouver, BC, Canada >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >bill@twg.bc.ca 604-431-9600 (voice) | UNIX & Network > 604-430-4329 (fax) | Systems Integration Bill, I have a report that cross-references columns...Look for colsxrf1.4gl in my toolkit. It's based on the ex30.4gl program. The tool kit is at my home page--yes it's free, and there's some other stuff there too. Just look for the word FREE. Your natural instincts will take over from there. Also available at emory.edu... There's also a pigs-eye entity-relationship report in troff/awk in the tool kit, but there's no guarantee that just because columns are named the same in different tables, that a relationship exists. ( Kinda like some marriages ) Anyway, they're there for your dissection and experimentation and possible use. Tim :-) -- \\\\|// (O|O) ==============================---o00--(_)--00o---============================ Tim Schaefer tschaefe@gate.net http://www.gate.net/~tschaefe And now a Florida FAQ ----------------------------------------------------------------------------- Q: What's a REDNECK Special? A: Catfish, shrimp, and gator balls, w/french fries, of course =============================================================================