SQL如下:
select a.table_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 in ('TABLENAME')
SQL如下:
select a.table_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 in ('TABLENAME')