Specifications

CHAPTER 3 Managing the Database
Users Guide 105
Representations of the selected tables and views display in the View
painter workspace:
3 Select the columns to include in the view and include computed columns
as needed.
4 Join the tables if there is more than one table in the view.
For information, see “Joining tables” on page 106.
5 Specify criteria to limit rows retrieved (Where tab), group retrieved rows
(Group tab), and limit the retrieved groups (Having tab), if appropriate.
For information, see the section on using the SQL Select painter in
“Selecting a data source” on page 154. The View painter and the SQL
Select painter are similar.
6 When you have completed the view, click the Return button.
7 Name the view.
Include view or some other identifier in the view’s name so that you will
be able to distinguish it from a table in the Select Tables dialog box.
8 Click the Create button.
InfoMaker generates a
CREATE VIEW statement and submits it to the
DBMS. The view definition is created in the database. You return to the
Database painter workspace with the new view displayed in the
workspace.