sa_recompile_views( [ ignore_errors ] )

This procedure is used to locate views in the catalog that do not have column definitions and execute an ALTER VIEW statement with the RECOMPILE clause to create the column definitions. The procedure does this for each view that does not have a column definition until there are none left that require compilation or until any remaining column definitions cannot be created. If the procedure is unable to recompile any views, an error is reported. Errors can be suppressed by specifying a non-zero parameter to this procedure.

The sa_recompile_views system procedure does not attempt to recompile materialized views or any view marked DISABLED.

You must have the ALTER ANY VIEW system privilege.

For each regular view that does not have a VALID status, an ALTER VIEW owner.viewname ENABLE statement is executed, causing an automatic commit.

• Statuses for regular views
• force_view_creation option
• ALTER VIEW statement

The following example from a reload.sql script uses the sa_recompile_views system procedure to locate view definitions stored in the catalog that do not have column definitions and cause the column definitions to be created. Errors are ignored.

CALL sa_recompile_views( 1 );