# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1516641318 -7200
# Node ID 303e4963ffc541701570036d766e1aa05527b3b2
# Parent  3b163a0580fc4da1a708786efb62d6f162bb561d
List tables that has foreign key to given table.

diff -r 3b163a0580fc -r 303e4963ffc5 oracle.rst
--- a/oracle.rst	Sat Jan 06 01:17:28 2018 +0200
+++ b/oracle.rst	Mon Jan 22 19:15:18 2018 +0200
@@ -155,6 +155,16 @@
     ) and OWNER in ('USER1', 'USER2')
     order by OWNER, TABLE_NAME;
 
+List tables that has foreign key to given table::
+
+  select * from SYS.USER_CONSTRAINTS cons
+    join SYS.USER_CONSTRAINTS rcons on rcons.CONSTRAINT_NAME = cons.R_CONSTRAINT_NAME
+    where cons.CONSTRAINT_TYPE = 'R' and rcons.TABLE_NAME 'TBL_NAME';
+
+  select * from SYS.USER_CONSTRAINTS cons
+    join SYS.USER_CONSTRAINTS rcons on rcons.CONSTRAINT_NAME = cons.R_CONSTRAINT_NAME
+    where cons.CONSTRAINT_TYPE = 'R' and rcons.TABLE_NAME like '%/_OLD' escape '/';
+
 List of current constraints limited to current user::
 
   select * from USER_CONSTRAINTS;