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
SQL applied to the settings is shown in the bottom SQL area.
Common
Set the Schema and Name of view to be created.
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.
Test the query by clicking [Test button] on the bottom right corner.
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.
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.
After completing the detailed settings on each tab, click [OK button] to create a View object with the settings.
Last updated