Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    5

    Unanswered: System table for Foreign key relations

    Hi,
    In which system table can I find all the Foreign Key relations of the different tables?
    Thanx,
    -Girish.

  2. #2
    Join Date
    Jan 2003
    Location
    Vienna, Austria
    Posts
    102

    Re: System table for Foreign key relations

    SELECT *
    FROM DBA_constraints
    WHERE constraint_type = 'R'
    ^/\x

  3. #3
    Join Date
    May 2003
    Posts
    45
    u can use this table as well
    user_constraints

    SELECT *
    FROM user_constraints
    WHERE constraint_type = 'R'

    this lists only user defined constraints

  4. #4
    Join Date
    Sep 2003
    Posts
    5
    Thanx guys..it worked just fine!!
    -Girish

Posting Permissions

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