Query the records that all foreign keys reference to a table in oracle.

Welcome to the Oracle community forum and interact with 2 million technical staff. Go to oracle to query all the foreign keys that reference the records of a table. query the table's primary key constraint name select * fromuser_constraintsewheree.table_name table name; -- input to query all records that reference this primary key, selectb. table_name, B. column _

Welcome to the Oracle Community Forum, interaction with 2 million technical personnel> go to oracle to query all records referenced by foreign keys to a table. // query the table's primary key constraint name select * from user_constraints e where e. table_name = 'table name'; -- enter // query all records referenced to this primary key select B. table_name, B. column _

Welcome to the Oracle community forum and interact with 2 million technical staff> enter

Query the records that all foreign keys reference to a table in oracle.

// Query the table's primary key constraint name

Select * from user_constraints e where e. table_name = 'table name'; -- Input

// Query all records that reference the primary key

Select B. table_name, B. column_name from user_constraints

Inner join user_cons_columns B

On a. constraint_name = B. constraint_name

Where a. r_constraint_name = 'Primary key name' -- Input