A new feature in Oracle SQL Developer Data Modeler is the ability to display table and view comments directly in the ERD. So I can go from this:
Normal Relational Diagram
Relational Diagram with Comments
Relational Diagram with Comments ONLY
Now the cool part is that I don’t have to pick. I can use all three depending on my need. Maybe I need a dev diagram for folks in the know, another diagram for biz users that need the built-in docs, and a 3rd higher level view that just explains the tables purpose.
We do this of course, with Displays.
And we configure what’s shown in a diagram by right-clicking in the diagram itself:
How can I find stuff with or without comments?
Maybe you want a report on the documented attributes, columns, entities, or tables in your model. It’s easy to find that, just do an advanced search and look where the value is NOT null.
Also a new feature in this version of the Modeler, doing NOT searches.
So show me tables where the comments aren’t blank:
And the results
To do the opposite search, just toggle off the ‘Not’ flag in the search parameters.