Question

用sql语句如何查看主键名

Answer 1

SELECT TABLE_NAME,COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE 
WHERE TABLE_NAME='表名'

Answer 2

select * from user_constraints s where s.TABLE_NAME=upper('emp') and s.CONSTRAINT_TYPE='P';