Create a View
Before you can create a database view, the
installation containing the database must be connected in the Instance Explorer (see
Connect to an Actian Database Instance).
You create a view using the
New View Dialog.
To create a database view
1. Open the New View dialog.
The Tables & Views page is displayed.
2. Specify a name for the view in the Name field.
3. On the Tables tab, select any user tables you want to include in the view. If you want to include system tables, check the Include System Objects option and select the system tables you want to include in the view.
4. On the Views tab, select any user views you want to include in the view. If you want to include system views, check the Include System Objects option and select the system views you want to include in the view.
6. If you want to include only particular columns, click Specify Columns and select those columns in the list.
The CREATE VIEW statement is built in the area at the bottom of the dialog.
8. Specify any query qualifiers in the Where Clause/Additional SQL text box.
9. Specify whether you want to enforce the view definition for inserts and updates with the With Check Option.
10. Click OK.
The view is created and added to the list of user views in the Instance Explorer.