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' /