查询表有主键

select distinct a.table_name--a.constraint_name,  a.column_name from user_cons_columns a, user_constraints b where a.constraint_name = b.constraint_name   and b.constraint_type = 'P' and a.table_name in  ('T_PM_MO_BASE','T_MES_BASE_MO','T_CO_ITEM','T_CO_AREA','T_WIP_DETAIL','T_PACKAGING_REPACK','T_MES_PLANAREASET','T_MES_XZLINE_STATUS','XWD_PLAN_TOTAL_INFO','T_MES_SST_PRDPLAN_DETAIL')