EKP 外键约束

 

 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

SELECT     C.CONSTRAINT_NAME,     C.TABLE_NAME "Child Table",     C.COLUMN_NAME "Child Column",     RC.OWNER "Parent Owner",     RC.TABLE_NAME "Parent Table",     RCC.COLUMN_NAME "Parent Column" FROM     ALL_CONS_COLUMNS C JOIN     ALL_CONSTRAINTS CT ON C.CONSTRAINT_NAME = CT.CONSTRAINT_NAME JOIN     ALL_CONSTRAINTS RC ON CT.R_CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN     ALL_CONS_COLUMNS RCC ON RC.CONSTRAINT_NAME = RCC.CONSTRAINT_NAME WHERE     C.CONSTRAINT_NAME = 'FKQEOOWE3JJQS3REJK6BQVOPIY5';                               select  *  from user_cons_columns cl  where cl.constraint_name = 'FKQEOOWE3JJQS3REJK6BQVOPIY5';