RENAME VIEW statement 

A RENAME VIEW statement changes the name of a view table (see Table).

Syntax

<rename view statement> ::= RENAME VIEW <old table name> TO <new table name>

<old table name> ::= <table name>
<new table name> ::= <table name>
 table name

Explanation

The old table name must be a view table. The current user must be the owner of the view table.

The new table name must not yet be used for a table of the current user.

The CREATE VIEW statement of the old table name view table is adapted to the new name. The result of this adaptation can be retrieved from the table DOMAIN.VIEWDEFS.

The definitions of view tables based on the old table name are adapted to the new name.