I have a database with over 50 tables.
I select over 50 tables and right mouse click to select "Send to ... | ER Diagram" from the list.
Toad returns that I exceeded the default setting:
This is more than the maximum set in the options: Do you want to limit the options to 50?"
I select "No" and Toad creates an ER diagram.
However, I am uncertain with that diagram because I cannot confirm if all 50+ tables are placed.
Right clicking on the background of the ER Diagram, and select "Properties" and I set the object details to "true" and "maximum objects" to 60.
This should re-send the 50+ tables tables to the ER diagram assuring all tables will be sent to the ER diagram
Back in the object explorer, the 50+ tables are still highlighted, and try sending them again to the ER diagram.
The same "Do you want to limit the options to 50" messaged is looped.
The setting the maximum number of tables does not appear to work.
WORKAROUND:
From the maim menu: Database | Diagramming | ER Diagram and Set "Maximum number of objects to add"
STATUS:
Waiting for fix in a future version of Toad for SQL Server.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center