Modifying Views
To modify a view:
1.In the Online Browser, right-click an existing view and select Show in new SQL Editor | Alter from the context menu. An ALTER VIEW statement with the definition of the existing view is displayed in a new SQL Editor window.
2.Modify the view as required.
3.Click the Execute 
button or press F5 to create the view.