Creating a view

Use the Create View window to create a view on one or more tables or views.

Fields and controls

Authorities and privileges

To create a view:

1. Open the Create View window.

2. Optional: Use the View schema list box to specify the schema for the view that you are creating.

3. In the View name field, type the lower-order (unqualified) identifier for the view that you are creating.

4. In the SQL statement box, edit the CREATE VIEW SQL statement.

5. Optional: Specify a Check option by clicking on either the Cascaded or Local radio button.

6. Optional: Type a comment in the Comment field.

7. Click OK to begin processing the SQL statement.

Related information

• Creating a view -- See the Administration Guide
• The CREATE VIEW statement -- See the SQL Reference
• More about schemas
• More about views
• Showing Commands or SQL