When I reverse Engineer some views don't show the columns of the view. I noticed that simple views with associated tables will show columns but more complicated views will not. It seems to me (and I've seen it in other ERD tools) that reversed views could simply show the list of aliased columns as defined on the view. I have been hunting around for a way to do this but have not had luck. Is there a way to do this?
Unfortunately the current Toad Data Modeler version is not able to manage/parse more complicated views and visualize them
and therefore they are treated in an old way as all views were treated before TDM 3.6. It means that a view is then loaded
as a definition to the SQL tab of View Properties, e.g. like
"AS
select first_name "First Name", last_name "EName", job_id "Job" from hr.employees"
This lacking of information in documentation will be added it in Views and RE chapters of TDM future updated documentation.
WORKAROUND:
None
STATUS:
Enhancement request has been submitted to the Toad Data Modeler Developement and Product Management teams.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center