There is more than one way to create a view. If you are an SQLprogrammer you can
open the code window and enter the SQLstatement. 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 SQLstatement using the view definition window.
The first option is easier if you code SQLand 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.