A view is a virtual table that you can use as a physical table to retrieve data defining columns from underlying views or tables, or both.
- In the Navigator, expand the Databases, right-click a database or user, and click Show Views. A list of the views defined in the connected system appears in the Object List Viewer. The list is filtered according to any filters you have applied.
-
In the Object List Viewer toolbar, click .
A Create View property form opens in the Details view.
- In the form, enter values for the new view.
- [Optional] Click the SQL category to see the SQL code that will be executed on the connected system to create the new view.
- Click Commit.
- Click OK. The property form shows the properties of the new view.