11.2.4 Rebuilding a viewed table
To rebuild a viewed table, execute the ALTER VIEW definition SQL statement. For details about the ALTER VIEW statement, see ALTER VIEW (re-create a viewed table) in the manual HADB SQL Reference.
A user (the HADB user with the authorization identifier that was used for the current connection to the HADB server) can rebuild only those viewed tables owned by that user. A user cannot rebuild viewed tables owned by other HADB users.
After the cause of invalidation of a viewed table has been removed, if you rebuild the viewed table by using the ALTER VIEW statement, you can release invalidation of the viewed table. For details, see 11.2.8 Releasing a viewed table from invalidation.
Note that the ALTER VIEW statement cannot change an existing view definition.
- Important
-
If you rebuild a viewed table, all viewed tables that depend on it are invalidated. Therefore, before you rebuild a viewed table, check whether there are viewed tables that depend on it, and make sure that there is no problem if those viewed tables are invalidated.