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

# Create View

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

**View Folder > Context Menu > Create View**&#x20;



The details can be set in each tab: [#common](#common "mention"), [#query](#query "mention"), [#view-info](#view-info "mention"), [#comment](#comment "mention")&#x20;

<figure><img src="https://content.gitbook.com/content/nNfkYJbwJttSkGBYdvi9/blobs/rsbTqFjXgBGjn7luKRnS/%EC%8A%A4%ED%81%AC%EB%A6%B0%EC%83%B7,%202025-02-27%2015-23-11.png" alt=""><figcaption><p>Create View screen</p></figcaption></figure>

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







## Common <a href="#common" id="common"></a>

Set the Schema and Name of view to be created.

<figure><img src="https://content.gitbook.com/content/nNfkYJbwJttSkGBYdvi9/blobs/AC6xphVpadHCakewjWgz/%EC%8A%A4%ED%81%AC%EB%A6%B0%EC%83%B7,%202025-02-27%2015-23-39.png" alt=""><figcaption><p>Create View - Common tab screen</p></figcaption></figure>

<table><thead><tr><th width="115">Field</th><th>Description</th></tr></thead><tbody><tr><td><strong>Schema</strong></td><td>Selects the Schema to create the view.<br>Default:  Schema currently created connection  </td></tr><tr><td><strong>Name</strong></td><td>Enters the name of view to be created.</td></tr></tbody></table>



## Query

Enter the query to create the view.

It provides auto-complete feature same as Editor.

<figure><img src="https://content.gitbook.com/content/nNfkYJbwJttSkGBYdvi9/blobs/gQp1RBCDYPJOlkivzexX/%EC%8A%A4%ED%81%AC%EB%A6%B0%EC%83%B7,%202025-02-27%2015-33-15.png" alt=""><figcaption><p>Create View - Query tab screen</p></figcaption></figure>

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

<figure><img src="https://content.gitbook.com/content/nNfkYJbwJttSkGBYdvi9/blobs/XxHxSgmnO8zTS0wjWGN3/%EC%8A%A4%ED%81%AC%EB%A6%B0%EC%83%B7,%202025-02-27%2015-35-17.png" alt=""><figcaption><p>Create  View - Query tab- Grid selection screen after clicking Test button</p></figcaption></figure>

<figure><img src="https://content.gitbook.com/content/nNfkYJbwJttSkGBYdvi9/blobs/ptMwV7I15TZpdLYy33Ln/%EC%8A%A4%ED%81%AC%EB%A6%B0%EC%83%B7,%202025-02-27%2015-35-47.png" alt=""><figcaption><p>Create View - Query tab- Plan selection screen after clicking Test button</p></figcaption></figure>

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.

<figure><img src="https://content.gitbook.com/content/nNfkYJbwJttSkGBYdvi9/blobs/j31ukVA8YuHh7Vg7HLxJ/%EC%8A%A4%ED%81%AC%EB%A6%B0%EC%83%B7,%202025-02-27%2015-36-16.png" alt=""><figcaption><p>Create View - View Info tab screen</p></figcaption></figure>



<table><thead><tr><th width="142">Field</th><th>Description</th></tr></thead><tbody><tr><td><strong>Force</strong></td><td>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.</td></tr><tr><td><strong>Restriction</strong></td><td><p>Selects the properties of the View defined by the Subquery.</p><ul><li>No Restriction</li><li>With Read Only: Makes the View created by the Subquery read-only so that it cannot be modified.</li><li>With Check Option: Update is allowed only if Select is possible.</li></ul></td></tr></tbody></table>



## Comment

Write a Comment for the View to be created.

Click **\[Reset button]** to initialize the created contents.

<figure><img src="https://content.gitbook.com/content/nNfkYJbwJttSkGBYdvi9/blobs/6xprEe5tAKpUnNWRSKfe/%EC%8A%A4%ED%81%AC%EB%A6%B0%EC%83%B7,%202025-02-27%2015-36-55.png" alt=""><figcaption><p>Create View - Comment tab screen</p></figcaption></figure>



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

###
