--表名
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 = '';
--表名
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 = '';