Filter
Top Products
CHAPTER 3 Managing the Database
DataWindow Designer User’s Guide 83
For information, see the section on using the SQL Select painter in
“Selecting a data source” on page 110. 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.
DataWindow Designer 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.
Displaying a database
view’s SQL statement
You can display the SQL statement that defines a database view. How you do
it depends on whether you are creating a new view in the View painter or want
to look at the definition of an existing view.
❖ To display the SQL statement from the View painter:
• Select the Syntax tab in the View painter.
DataWindow Designer displays the SQL it is generating. The display is
updated each time you change the view.
❖ To display the SQL statement from the Database painter:
• Highlight the name of the database view in the Objects view and select
Properties from the pop-up menu, or drag the view’s icon to the Object
Details view.