Monday, September 29, 2014

List all references to a table in Oracle

Got this query from this blog: http://www.dba-oracle.com/t_find_all_references_to_oracle_table.htm
select * from all_constraints
where r_constraint_name in
    (select constraint_name from all_constraints
      where table_name='TABLE_NAME');