View

When you login to the database, you can see accessible views and system views in the navigation tree.

Create View

Right-click [Views] in the navigation tree and then select [Create View].

Specify the view name and the owner, click the [Add] button, and then enter the query for the view to be created. You can check the contents entered in the Create View wizard from the SQL statement in the [SQL Script] tab.

Select All

Right-click a view in the navigation tree and click [Select All]. Or you can drag and drop the view into the editor results pane of the Query editor when it is open. Then, a new Query editor opens and retrieves the entire data.

Select Count

Retrieves a total data count of the table and performs the same functionality as the following syntax.

SELECT COUNT(*) FROM view

Export Data

You can export all data of the view to an Excel, CSV, SQL or CUBRID load format.

Drop View

Drops the selected view. This is same as the DROP VIEW statement.

Rename View

You can change the name of the current view.  This is same as the RENAME VIEW statement.

Edit View

You can use all functionalities of [Create View] in [Edit View] as well.

View Information

You can check the schema information of the view by double-clicking it.