Procedure documentationRenaming View Tables Locate this document in the navigation structure

 

Note Note

You can only change names of view tables, but not any other properties.

End of the note.

Prerequisites

  • You are logged on to the database as a database user.

  • You are the owner of the view table and have CREATIN privilege for the schema to which the view table belongs.

    More information: SQL Reference Manual, Privilege Specification for a Schema (schema_priv_spec)

  • The database is in the ONLINE operational state.

Procedure

  1. Select the view table in the explorer tree.

  2. In the context menu of the view table, choose Definition.

  3. In the context menu of the editor window, choose Edit.

  4. Change the name of the view table.

  5. In the context menu of the editor window, choose Alter View.

More Information

SQL Reference Manual, RENAME VIEW Statement (rename_view_statement)