How can I find which tables reference a given table in Oracle SQL Developer?

by

No. There is no such option available from Oracle SQL Developer.

You have to execute a query by hand or use other tool (For instance PLSQL Developer has such option). The following SQL is that one used by PLSQL Developer:

select table_name, constraint_name, status, owner
from all_constraints
where r_owner = :r_owner
and constraint_type="R"
and r_constraint_name in
 (
   select constraint_name from all_constraints
   where constraint_type in ('P', 'U')
   and table_name = :r_table_name
   and owner = :r_owner
 )
order by table_name, constraint_name

Where r_owner is the schema, and r_table_name is the table for which you are looking for references. The names are case sensitive

Be careful because on the reports tab of Oracle SQL Developer there is the option “All tables / Dependencies” this is from ALL_DEPENDENCIES which refers to “dependencies between procedures, packages, functions, package bodies, and triggers accessible to the current user, including dependencies on views created without any database links.”. Then, this report have no value for your question.

More Related Contents:

  1. SQL function PIVOT with 2 column
  2. How to load a large number of strings to match with oracle database?
  3. Can a foreign key be NULL and/or duplicate?
  4. Oracle SQL escape character (for a ‘&’)
  5. Foreign Key Creation issue in Oracle
  6. How to extract week number in sql
  7. How to use Timestamp_to_scn and Scn_to_timestamp in Oracle?
  8. Exporting a CLOB to a text file using Oracle SQL Developer
  9. How do I limit the number of rows returned by an Oracle query after ordering?
  10. When do I need to use a semicolon vs a slash in Oracle SQL?
  11. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  12. LISTAGG in Oracle to return distinct values
  13. Fetch the row which has the Max value for a column
  14. Oracle SQL: Update a table with data from another table
  15. Oracle SQL – How to Retrieve highest 5 values of a column [duplicate]
  16. Concatenate and group multiple rows in Oracle [duplicate]
  17. SQL Error: ORA-00933: SQL command not properly ended
  18. Convert a string date into datetime in Oracle
  19. Benefits Of Using SQL Ordinal Position Notation?
  20. Unordered results in SQL
  21. Oracle Dynamic Pivoting
  22. What is it exactly a BLOB in a DBMS context
  23. Custom Order in Oracle SQL
  24. How do I list all tables in a schema in Oracle SQL?
  25. oracle sql: update if exists else insert [duplicate]
  26. Compare Strings ignoring accents in SQL (ORACLE)
  27. What does a (+) sign mean in an Oracle SQL WHERE clause? [duplicate]
  28. Connecting to Oracle Database using Sql Server Integration Services
  29. ORA-00933: SQL command not properly ended
  30. Update a table with data from another table

Leave a Comment