Displaying Attributes in View

Toad Data Modeler
1

Hello,

I reverse engineered views in TDM 5.5.

Is there any option to display view attributes in the diagram ? I could see create SQL in SQL preview tab, but attributes tab is empty. Please advise.

Thanks !!

2

Hello raaj,
in TDM can use two type of Views.

  1. Simple Views, with attributes, that can be displayed on designers
  2. Other Views (more complicated) that is modeled only as text on SQL Tab

TDM are not able to reverse and model some views as first type.
Please select checkbox "SELECT in Views as Text" on View Properties Form. When it is checked it is second type and tabs Attribtues, Where, Order, Group and Having are disabled. When it is unchecked it is first type and tab SQL is disabled.

image
image.png491×607 14 KB

Regards
Daril