View#

Create#

Right-click on the view in the database object tree and select New. Edit the view statement and click OK to create the view.

Edit#

Right-click on the view in the database object tree and select Edit. Edit the view statement and click OK to modify the view.

Rename#

Right-click on the view in the database object tree and select Rename. Enter the new view name and click OK to complete the renaming.

Drop#

Right-click on the view in the database object tree and select Drop. A confirmation pop-up will appear. Click OK to drop the view.

Script#

View DDL#

Right-click on the view in the database object tree and select Script -> View DDL. You can view and copy the DDL statement in the pop-up box.

Generate Select#

Right-click on the view in the database object tree and select Script -> Generate Select.... View the statement in the pop-up box.