Hi All,
How to find the objects that depend on a given object and those that a given object depends on.
Example:
Procedure works with two tables, three functions and one view. This procedure can be used in another procedure.
I want receive full dependencies tree by name (and maybe type) of given object as in SQL Server.
Is exists the way to receive such info ?
Ira,
We don’t have this available exactly. You could approximate it by string matching in the body of a function in information_schema.routines or information_schema.views.