SELECT A.TABLE_NAME,A.CONSTRAINT_NAME,B.COLUMN_NAME
FROM USER_CONSTRAINTS A,  USER_CONS_COLUMNS B
WHERE A.CONSTRAINT_NAME = B.CONSTRAINT_NAME
AND A.CONSTRAINT_TYPE ='P'
AND A.TABLE_NAME = '&TABLE'
/
Hosted by www.Geocities.ws

1