Unique Indexes!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Unique Indexes!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    Hi !

    1.I have a table called EMPLOYEE having composite primary
    keys defined on EMPNO,ENAME.

    Now when I query from user_constraints:

    select constraint_name,constraint_type
    from user_constraints
    where table_name = 'EMPLOYEE';

    I get the information like:

    constraint_name

    EMP_PK
    SYS_C0098
    SYS_C0010
    etc.,

    Now I would like to know what is this SYS_C0098 etc.,

    regards,

    Amitstora.



  2. #2
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    You need to look at the rest of the columns in that view - those 2 constraints are most likely NOT NULL constrainsts on your 2 PK columns.

    - Chris

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