You can replace the SQL definition of an existing view.
In the left pane of the Administration Console, expand ASE Servers > Compiled Objects > Views.
Choose one of the following:
Click the drop-down arrow on the view for which you want to replace the
definition and select Replace.
From Views in the left pane, click the drop-down arrow and select
New. Enter the name of the existing view for which you
want to replace the definition.
When selecting an existing view, the
Confirm Replace dialog appears with an option to
replace the object definition or cancel the replacement.
(Optional) On the SQL Editor screen, enter the new view value.
(Optional) On the Summary screen, verify the view name, database, owner, and the
new expression.