Database Diagram not showing relationship of dependencies (reference depth set to 1)

Toad Data Point
1

Hi all,

I was trying to draw diagram in Toad Data Point 4.1 to show a view and its dependencies, but no dependency listed except the view itself, and the “referenced objects” at the bottom is empty.

I tried both a view created from a written SQL script, and a view from Query builder. Neither worked. Did I miss something?

Thanks for your help.

2

Hi,

ER Diagram shows reference relations between tables. Such relations are usually implemented using Foreign key so it automatically draws foreign key relation. ER Diagram does not show dependencies, such as the views that depend on a table or view.

Regards

Aleksey

3

Thanks Aleksey. I see.

Do you happen to know is there a way to show dependencies in TDP?

Thanks,

Tracy

4

Hi Tracy,

I am sorry but there is no such functionality in TDP.
You could try to google for a query that returns view dependencies for your database.

Regards

Aleksey

5

if you are using any of our native connectors, such as Oracle, SQL Server, DB2, or MySQL you can see the definition of the view in the script tab of the Object Explorer