Schema Design via PL SQL Developer Tool

[chandu]

Hi All,
I am a bit new to PL SQL Developer Tool, I want to know if there is an option or a syntax to view the Schema Design via PL SQL Developer Tool.
If so then kindly let me know.

 

[Worker]

You can open a Diagram Window (File->New->Diagram Window), select all tables in the Object Browser (open the "Tables" folder, click the first table and shift-click the last table), and drag all tables into the Diagram Window.

Then you can spend the next 2 hours dragging windows and lines around to make it look pretty, and then, hopefully, you'll have what you're looking for.

(If there's a better way to do this, either with PL/SQL Developer or another tool, I'd love to hear about it too.)

 

[rbrooker]

you could try the QuickER plugin, that is really good. has an auto layout feature. you are limited to 10 objects until registered tho.

http://www.gotterup.net/quicker

just tried going there but the server didnot respond.

if you need a copy of it, i can email you one.

 

[Worker]

from http://www.allroundautomations.com/plsqldevplugins.html:
Note that Quick/ER will not work under PL/SQL Developer version 7.1. We hope for a solution from the developer.

 

[rbrooker]

true, but what version plsd is chandu using? it may not be 7.1

 

[chandu]

Hi All,
I am using PL SQL Developer V 6.0.5 , so I would try which you wanted me to. Lets see how it works. But how to use the file, any guidelines pls
THanks
Chandu

 

[rbrooker]

download the plugin from the links on the plugins page. run the executable, it will install the dll into the correct place for you.

next time you start plsd, there will be a yellow toolbar icon that you can press ( once connected ) that will open a diagram window. then its a case of drag and dropping items into the window.