Oracle foreign key table search

Oracle foreign key table search

SQL code Select B. table_name primary key table name, B. column_name primary key column name,. table_name foreign key table name,. column_name foreign key column name From (Select. constraint_name, B. table_name, B. column_name,. r_constraint_name From user_constraints a, user_cons_columns B Where. constraint_type = 'r' And. constraint_name = B. constraint_name) a, (Select Distinct. r_constraint_name, B. table_name, B. column_name From user_constraints a, user_cons_columns B Where. constraint_type = 'r' And. r_constraint_name = B. constraint_name) B Where. r_constraint_name = B. r_constraint_name and B. table_name = 'jdt _ DEPARTMENT'