Differences

This shows you the differences between two versions of the page.

--- kurs:foreign_keys_finden [2014/09/10 21:22]
+++ kurs:foreign_keys_finden [2014/09/10 21:22] (current)
@@ Line 1: / Line 1: @@
+<code>
+select owner,constraint_name,constraint_type,table_name,r_owner,r_constraint_name
+from all_constraints where
+-- constraint_type in ('P','U') and
+table_name='EMPLOYEES';
+</code>
+<code>
+select *
+from
+   user_dependencies
+ where referenced_type = 'TABLE'
+order by
+   name, referenced_owner, referenced_name, referenced_type
+</code>

dokuwiki