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 Databases, right-click a database or user, and select Show Views.
- In the Object List Viewer toolbar, click
. - Enter values for the new view.
- [Optional] Click the SQL tab to see the SQL code that will be executed on the connected system to create the new view.
- Click Commit then OK.