Create view wizard

Create view wizard allows users to create a view. You can invoke the wizard by right click on the “Views” node in the database explorer, and choose the “Create View” menu option. The following shows the “Create View” wizard.

Please enter the view name in this page, and then click the “Next” button to go to the “Select database objects” page.

Please select the tables, views and synonyms that the view is based on, then click the “Next” button to go to the “Select columns” page.

Please select the view columns, and then click the “Next” button to go to the “Execute script” page.

The join conditions of the view script are created based on the table relationships. Please modify the script as needed, and then click the “Finish” button to execute the script. The database explorer will be refreshed to display the newly created view.