How to hide many small table in view data model ?

[paulyeo11]

Hi All

My data model alway very confuse , and i like to know it there a way to hide these small table ?

[#2]

Hi,

Better use a link table.

[sunny_talwar]

I doubt that it is possible.

[tresesco]

AFAIK, not possible.

[Digvijay_Singh]

I don't think it is possible, even you arrange them one above other and minimize as much as possible, they may appear differently when we make any further changes in data model?

[krishna20]

Hi

tresesco

and

sunindia

what happens if we drop that ISLAND tables? whether we can use that fields in the expressions or not??

If we can use those fields in the expressions. We can drop that tables to minimize the datamodel structure right??

Please clarify this doubt.

[sunny_talwar]

Once dropped from the script, the fields in the ISLAND tables cannot be used anymore cause they are not available in data model anymore.

[krishna20]

Thank you sunny...

[sunny_talwar]

No problem friend

[petter]

You can achieve to "hide" tables in the Table Viewer by making each window as small as possible and then stack them on top of each other. Finally you make a dummy table in the end of your load script which you give a name like "DATA MODEL FOR APPLICATION XYZ". This one you make only as tall as the title line and as wide as you need to show the table name. And then you place this on top of the others. Have a look at my image where it has 5 hidden (behind) tables and one dummy table on top to cover them all that pose as a title for the entire data model.

This next screenshot shows the 5 hidden tables stacked on top of each other but with the "title" table moved up so it doesnt cover them anymore...

This layout manipulation will stay in effect through saves and reloads. But if you press Auto-Layout in the Table Viewer you will have to manually resize, move and restack the things you want to "clean" up visually...