select pk and fk from user_tables

[rubychyld]

I would like to know the correct syntax for something like this...

select * from user_constraints where table_name = 'employee';

I am new to this, and am having trouble seeing my primary keys, foreign keys, and user check constraints after they are created. (I'm using SQLPlus - oracle 8i)

thanks so much for sharing...
Liz

 

[carp]

You need to specify the table name in upper case:

select * from user_constraints where table_name = 'EMPLOYEE';

Your primary key will have a constraint_type code of 'P' while foreign keys will have a code of 'R'.