查询主键是哪几列

----查询主键是哪几列
select table_name,column_name from user_cons_columns a,(
select constraint_name from user_constraints where table_name='TR_COUNTRY_BASE_M' and constraint_type='P'---主键约束名称
) b where a.constraint_name=b.constraint_name
order by position
;

原文地址:https://www.cnblogs.com/jiangqingfeng/p/10955606.html