Mysql table에서 pk 찾기

select C.COLUMN_NAME from USER_CONS_COLUMNS C, USER_CONSTRAINTS S

where C.CONSTRAINT_NAME = S.CONSTRAINT_NAME and S.CONSTRAINT_TYPE = 'P' 

AND C.TABLE_NAME = '찾을 table명(대문자로 쓸것)';