[bobbruno]

I have an issue with calling any of the diagrams created by all the tools mentioned "ER Diagrams". Entities are not the same thing as tables, and Sr diagrams are not relational database table diagrams. A (semi) visual representation of a database schema of any size that'd require a visual representation is almost necessarily a mess, and doesn't really help discussion or design. It is at best a faster indexing into the DDL for the tables.

What I'd love to have (but never saw an affordable tool) is the ability to work at different levels of abstraction: physical (which is what all tools here actually do), logical (hiding field details, normalization and de normalization, giving better business entity names, etc) and conceptual (to show how big picture concepts relate, domain boundaries, department dependencies/relationships).

Just the physical representation does, for my purposes, little more than code highlighting.