Create View

It describes how to create the view object with Gui Operation.

View can be created through the GUI operation as executing the following process.

View Folder > Context Menu > Create View

The details can be set in each tab: Common, Query, View Info, Comment

Create View screen

SQL applied to the settings is shown in the bottom SQL area.

Common

Set the Schema and Name of view to be created.

Create View - Common tab screen

Field	Description
Schema	Selects the Schema to create the view. Default: Schema currently created connection
Name	Enters the name of view to be created.

Query

Enter the query to create the view.

It provides auto-complete feature same as Editor.

Create View - Query tab screen

Test the query by clicking [Test button] on the bottom right corner.

Create View - Query tab- Grid selection screen after clicking Test button

Create View - Query tab- Plan selection screen after clicking Test button

Click [Test button] to check the execution result and plan of the query created.

Click [Reset button] to initialize the created contents.

View Info

sets the information of the view to be created.

Create View - View Info tab screen

Field	Description
Force	Selects whether to create a View forcibly regardless of whether the object referenced by the View exists or not, or the permission to the object referenced.
Restriction	Selects the properties of the View defined by the Subquery. No Restriction With Read Only: Makes the View created by the Subquery read-only so that it cannot be modified. With Check Option: Update is allowed only if Select is possible.

Comment

Write a Comment for the View to be created.

Click [Reset button] to initialize the created contents.

Create View - Comment tab screen

After completing the detailed settings on each tab, click [OK button] to create a View object with the settings.