Auto-Generated ERD Diagrams

[Jim Oriotis]

We have many tables (thousands) with PK/FK relationships

Our clients would like ERD diagrams but trying to make a one to show the whold system would be be ridiculously large, take to long to generate, ...

What we would like a way to "AUTO-GENERATE" diagrams (to what ever layout PL/SQL Developer defaults)
for a list of tables (1 to 10)
from the command line and save the files

This would allow us to constantly update these files as we update our tables
and provide them to our clients as images or better yet .pdd (so they would need to purchase PL/SQL Developer to look at them)?

The generated .pdd files seem to be simple text

Do you have a document specifying the complete format of a .pdd file?

 

[Marco Kalter]

There is currently no option to auto-generate diagrams. You would need to explicitly create a diagram for each selection of tables.

 

[Jim Oriotis]

I didn't thing there was an auto-generate, but I was hoping I missed something in the documentation.

No worries.

Do you have a document specifying the complete format of a .pdd file?

I could query dba_objects and generate the .pdd file using SPOOL if I knew the .pdd structure/syntax as it seems to be a PLAIN TEXT file.