Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Enquiring PK Columns
How can we know which columns of a table is part of the primary key ? The
all_constraints view doesnt provide such an info - it just tell whether a
table has a pk constraint or not (by the existence of constraint_type='p').
Thx for any advice. Received on Fri Jan 14 2005 - 07:37:05 CST