oracle ²é¿´Ö÷Íâ¼üÔ¼Êø

select a.constraint_name, a.table_name, b.constraint_name 
from user_constraints a, user_constraints b
where a.constraint_type = 'R' 
and b.constraint_type = 'P' 
and a.r_constraint_name = b.constraint_name
P ´ú±íÖ÷¼ü
R ´ú±íÍâ¼ü
ͨ¹ý¹ØÁª£¬Äܲéѯµ½ÄãËùÏëÒªµÄÒ»ÇС£
select constraint_name from dba_cons_columns where table_name='';
Alter table XX drop constraint sys…
/////////////////////////////
user_constraints,user_cons_columns²é¿´Íâ¼ü
Oracle ²é¿´Ò»¸ö±í¶ÔÓ¦µÄÖ÷¼üºÍÍâ¼üµÄÔ¼Êø¹Øϵ£¬²é¿´µÄÓï¾ä£º
select a.owner Ö÷¼üÓµÓÐÕß
         ,a.table_name Ö÷¼ü±í
        ,b.column_name Ö÷¼üÁÐ
        ,C.OWNER Íâ¼üÓµÓÐÕß
        ,c.table_name Íâ¼ü±í
       ,d.column_name Íâ¼üÁÐ
from user_constraints a
left join user_cons_columns b
            on a.constraint_name=b.constraint_name
left join user_constraints C
            ON C.R_CONSTRAINT_NAME=a.constraint_name
left join user_cons_columns d
            on c.constraint_name=d.constraint_name
where a.constraint_type='P'
    and a.table_name='XXX' --ÐèÒª²é¿´Ö÷Íâ¼ü¹ØϵµÄ±í
order by a.table_name
ÄþÍâµÄÒ»ÖÖд·¨
select
a.owner Íâ¼üÓµÓÐÕß,
a.table_name Íâ¼ü±í,
substr(c.column_name,1,127) Íâ¼üÁÐ,
b.owner Ö÷¼üÓµÓÐÕß,
b.table_name Ö÷¼ü±í,
substr(d.column_name,1,127) Ö÷¼üÁÐ
from
user_constraints a,
user_constraints b,
user_cons_columns c,
user_cons_columns d
where
    a.r_constraint_name=b.constraint_name
and a.constraint_type='R'
and b.constraint_type='P'
and a.r_owner=b.owner
and a.constraint_name=c.constraint_name
and b.constraint_name=d.constraint_name
and a.owner=c.owner