--表名

select * from user_constraints e where e.table_name = '';

?

?

?

--主键约束名称

select b.table_name,b.column_name from user_constraints a

inner join user_cons_columns b on a.CONSTRAINT_NAME = b.CONSTRAINT_NAME

where a.R_CONSTRAINT_NAME = '';