Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Posts
    2

    Unanswered: Relation of Tables

    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!!!

  2. #2
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    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
    ***********************************************

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •