User Guide : 6. Working with Databases : Working with Views : Create a View
 
Share this page                  
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.
Names must follow Object Naming Rules.
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.
5. Click the Columns page link (see New View Dialog).
6. If you want to include only particular columns, click Specify Columns and select those columns in the list.
7. Click the Additional SQL page link (see New View Dialog).
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.