ThatJeffSmith

Adding and Removing Objects from a SQL Developer Data Modeler SubView

SubViews are a sub-collection of model objects. They are very useful for breaking up very large designs into smaller, easier to digest pieces. If you need to brush up on the topic a bit, try these posts.

I recently received a note from a user, we’ll call him ‘Galo’ – who was having problems figuring out how to add a table to an existing subview.

It actually took me a few minutes to figure out. And ‘Galo’ actually figured it out on his own as well. But just in case you lack the patience or time to go through this puzzle, let’s show how easy it is to add and remove objects to and from SubViews.

No Existing SubView – Create And Add Objects

You can multi-select objects in the diagram, right-mouse-click, and say ‘Create SubView from selected.’

Nice for adding a few objects close together...

Nice for adding a few objects close together…

You can also Create a Subview from Neighbors – a nice trick/click off of the model tree. Basically allows you to pick one driving object, and say take this and any related objects and move to a subview.

Add An Object to an Existing SubvView

This is where Galo and I got stuck. But it’s intuitive, once you do figure it out :)

Just drag it over from the tree to the SubView diagram

Just drag it over from the tree to the SubView diagram

Removing Objects from a SubView

Right-click on the object in the diagram, right-mouse-click, ‘Delete View.’ This will remove it from the SubView ONLY. If you say ‘Delete Object,’ it will remove it from the model entirely.

If you use the ‘Delete’ context menu from the SubView item in the tree – it again deletes the object from the design entirely! You can always UNDO this :)

Version 4.0.1 Makes it a Bit Easier

In the latest version, there’s a new dialog to manage what’s in and out for a SubvView.

Right click in the SubView diagram space...

Right click in the SubView diagram space…

And then you get this:

You can use the Filter input to auto find the objects you want to add or remove.

You can use the Filter input to auto find the objects you want to add or remove.

I’ve asked for every view with the text ‘BLOG’ in the name. I can then use the ‘Select All’ button and say ‘Apply.’ Voila!

Hmmm, that doesn't look quite right.

Hmmm, that doesn’t look quite right.

Don’t forget you can use the ‘Auto Layout’ to arrange your diagram objects to a more pleasing set of coordinates. Just right-click in the diagram to try the 4 different automatic layouts.

I generally like the first one best.

I generally like the first one best.