Hi,

how can I find out which column of a Table is referneced to a column of the other Table.
I mean for Example:
The first Table has a column as a Foreign Key. And the second Table has a column as a Primary Key. Now I want to display with a Select Statement that if the two tables are referenced!

In Oracle I can see the relation in the Data Dictionary!
And how in Informix?

Thanks!!!

Check this thread from 2003-02-06 (last thursday) in
the newsgroup comp.databases.informix:

"How to get foreign key reference table in systables"

Best regards

Eric
--
IT-Consulting Herber
WWW: http://www.herber-consulting.de
Email: eric@herber-consulting.de

***********************************************
Download the IFMX Database-Monitor for free at:
http://www.herber-consulting.de/BusyBee
***********************************************