Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 8 down vote favorite

Are VIEWS (CREATE VIEW) represented in an ERD? If so, how do you represent them and specify what tables they came from?

share|improve this question
1  
Not sure if this'll help you or not, but here's a post highlighting a Toad feature that does this with some screenshots. Maybe it will at least give you some leads. toadworld.com/Blogs/tabid/67/EntryId/573/… – squillman Jul 17 '12 at 14:31
1  
As far as I can remember, PowerDesigner allows you to represent a view using a notation similar to that of a table but with a special icon near the table name. If your tool does not provide for this use a naming standard to distinguish views from table and or/color. – Emmad Kareem Jul 17 '12 at 20:33

1 Answer

up vote 4 down vote accepted

There is a view object available in several ERD tools that I've seen (TOAD, Agilian, Visio). I'm not entirely sure that it is formally a part of any notation, but could be construed as a stereotype, as it is effectively just another entity.

Demonstrating the relationship to the source tables is a bit more difficult, IMO. I would just use a generic connector, especially as the relationship is likely much more complex than can be described visually (I just created a view that is populated in part by functions that run complex queries on multiple tables). I would absolutely not use the relationship connectors.

share|improve this answer
Maybe the formal notation came first and they added the VIEWs later... – leeand00 Jul 17 '12 at 16:39

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.