In Toad, you can check the PL/SQL program’s list (procedures, functions, triggers, etc.) which depends on a particular table in the Oracle database. Follow these steps to find the table dependencies in Toad for Oracle.
Find The Dependencies For a Table in Toad For Oracle
- After connecting to your database user in Toad, click on the menu Database > Schema Browser.
- Then from the Table’s tab, select the table for which you want to find the dependencies.
- When you select the table by clicking on it, the right side multiple tabs window will display the information about the selected table.
- Then click on the Used By Tab to view the dependencies for the table. You can also check the Referential Tab to check the parent and child tables for the selected database table. Below is the screenshot.
You can also view the dependencies for a table from the database dictionary view ALL_DEPENDENCIES. The following is the query to check the dependencies for the HR schema’s Employees table.
SELECT * FROM ALL_DEPENDENCIES WHERE REFERENCED_NAME = 'EMPLOYEES';
The output would be the same as above.