Unique Indexes!

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.

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