Carl Prothman
Reputation: 1551
How to Create Table Dependecy Tree - Oracle
Given an Oracle table, how can I found out what depends on that table? e.g. Which Views, Functions, Stored Procs, etc.
One would think it would be easy given Oracle SQL Developer or Aqua Data Studio, but they don't contain that feature. How frustrating!
Upvotes: 0
Views: 1029
Answers (1)
tariq
Reputation: 615
In Aqua Data Studio, connect to your Oracle Server and Expand your Tables node under the Schema Browser. Pick your table, right click and select Table Properties. Navigate to the Dependencies tab and you can see all the dependencies.
Upvotes: 1
Related Questions
- how to create inherited table in oracle
- How to list tables in their dependency order in oracle (based on foreign keys)?
- Integrate a tree in oracle
- How to get unique hierarchy on table dependencies
- SQL Creating Table Dependencies
- PL SQL Find Dependencies on Table Field
- Building a Table Dependency Graph With A Recursive Query
- PostgreSQL design of dependency tree without circular dependencies
- Table design like tree view in oracle
- functional-dependencies example