Skip to Main Content
Database Modeling with Microsoft® Visio for Enterprise Architects
book

Database Modeling with Microsoft® Visio for Enterprise Architects

by Terry Halpin, Ken Evans, Pat Hallock, Bill Maclean
September 2003
Intermediate to advanced content levelIntermediate to advanced
425 pages
16h 30m
English
Morgan Kaufmann
Content preview from Database Modeling with Microsoft® Visio for Enterprise Architects
12.7 Views
There is more than one way to create a view. If you are an SQL programmer you can
open the code window and enter the SQL statement. This provides code for the DDL
script. This does not create a view symbol on the diagram. The other option is dragging
a view shape from the ER stencil onto the drawing. You can then create the view and
the SQL statement using the view definition window.
The first option is easier if you code SQL and care to do so directly. The code win-
dow is opened by selecting from the main menu bar Database > View > Code. Select
Global Code (Figure 12–17) to open an instance of the code window. When using the
code window ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Mastering Data Modeling: A User-Driven Approach

Mastering Data Modeling: A User-Driven Approach

John Carlis
Architecting Data-Intensive SaaS Applications

Architecting Data-Intensive SaaS Applications

William Waddington, Kevin McGinley, Pui Kei Johnston Chu, Gjorgji Georgievski, Dinesh Kulkarni
Limitless Analytics with Azure Synapse

Limitless Analytics with Azure Synapse

Saranya Ravichander, Prashant Kumar Mishra

Publisher Resources

ISBN: 9781558609198