A picture says more than a thousand words. I received an existing database to be used in an application. The database is pretty complex: it has over 40 tables and there is not that much documentation. The diagram wizard in the SQL enterprise manager proved very usefulll to generate some diagrams which displayed quite clearly what the database was about.
When you create a new diagram in SQL manager a wizard pops up; it asks for a table to add to the diagram. The best part is the “Add related tables automaticaly” checkbox.
When checking that the wizard adds all all tables having a primary or foreign key relation with the selected table and fits them in a quite nice layout.
Impresive, but somewhat intimidating. You can set the number of levels you want to add. Raising this to two:
Wow ! All of this without any manual manipulation. Very very usefull
Peter