Toad World® Forums

ERs for views


#1

From the TDM2 Yahoo! group:

I can see a graphic depiction of the view but it is seriously lacking. If I have a view that it based on two entities and the view and the two entities are displayed on the workspace, there should be a visible connection between the view and the entities. Also, there is no visual indication of what attributes are in the view. It’s just a dashed-line bubble on the display. I think I need to carry this conversation to the TDM3 community for enhancements.

-----Original Message-----
From: toaddm@yahoogroups.com [mailto:toaddm@yahoogroups.com] On Behalf Of Bert Scalzo
Sent: Thursday, August 02, 2007 9:47 AM
To: toaddm@yahoogroups.com
Subject: RE: [toaddm] Reverse Engineering - views don’t appear

in toad data modeler 2.x views are reverse enginnered into text objects - but not shown visually, but they will come back out when genrating DDL since they are there in toad data modeler 3.x (beta right now), views will be shown graphically - try out the beta and see if it suffices … bert


#2

The generated SQL is also missing the ‘create or replace view’ statement in the SQL.

How do I specify the order of the generated SQL for views. I have a couple of views that are based on another view so I don’t want the dependent views to get executed until the master view is defined.


#3

Hello,

Let me quote Bert’s reply from the Yahoo group:“you are correct - but we don’t yet parse SQL - so we’re limited for now - but it’s on the roadmap …”

How do I specify the order of the generated SQL for views.

Please select Model | Order of Generated Objects. Find the Views section and use the green arrows to change the order.

Regards,

Vladka


#4

If there are known dependencies (and there in fact are in TDM3 - foreign keys) for views, tables, TDM3 should know the order automatically.

I know that in CS2 it was a common problem that rebuilding of tables with drop commands was problematic because of wrong order of automatic generated commands.


#5

Still working on dependencies (many of them are missing in TDM3, e.g. between a table and views).

We will deal with this issue in the future. Thanks for your patience.

Vladka