question Tabloma hangi tablolardan Foreign key var nasıl anlarım?

1. // @author kenan | 16 Mayıs 2017

   select table_name, constraint_name, status, owner
   from all_constraints
   where r_owner = :SEMA_ADI
   and constraint_type = ‘R’
   and r_constraint_name in
   (
   select constraint_name from all_constraints
   where constraint_type in (‘P’, ‘U’)
   and table_name = :TABLO_ADI
   and owner = :SEMA_ADI
   )
   order by table_name, constraint_name

// Comments are closed.