Replacing a View Definition

You can replace the SQL definition of an existing view.

  1. In the left pane of the Administration Console, expand ASE Servers > Compiled Objects > Views.
  2. 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.

  3. (Optional) On the SQL Editor screen, enter the new view value.
  4. (Optional) On the Summary screen, verify the view name, database, owner, and the new expression.