Views

Creating views

1. Go to Databases
2. Select the database in which you want to create a view.
3. Select the schema in which you want to create a view.
4. Go to the DB Objects > Views tab.
5. Click Create view.
6. Type a name for the view. The name can be up to 128 characters long and it must begin with a letter or underscore and cannot contain embedded spaces. The name must be unique. If the name contains special characters, enclose it in double quotation marks.
7. Specify whether the view is materialized.
8. Specify the query. Enter the SQL query that provides the columns and rows of this view. If the database object name contains special characters, enclose it in double quotation marks.
9. Click Create.

You can select Assign owner, Rename, and Drop options from the overflow menu.