DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Which constraint relates to which column

  1. #1
    Join Date
    Dec 2007
    Posts
    16

    Which constraint relates to which column

    Hi,

    I've queried the dba_constraints table to see which constraints one of my tables has, and have the following results:
    Code:
    TABLE_NAME       Con. Name        T 
    ---------------- ---------------- -
    CUSTOMER         SYS_C004465      P
    CUSTOMER         SYS_C004466      R
    Is there anyway I can find out which column name these constraints relate to?

    Thanks

  2. #2
    Join Date
    Apr 2003
    Posts
    353
    Dba_cons_columns

  3. #3
    Join Date
    Dec 2007
    Posts
    16
    Thats exactly what i was after, thanks engiri.

Posting Permissions

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


Click Here to Expand Forum to Full Width