Name

ALTER VIEW

Synopsis

ALTER VIEW
[schema.]view_name
COMPILE

Recompiles a view (view_name). The COMPILE keyword is required.

Notes

You must own this view or have the ALTER ANY VIEW privilege to issue this command. This command is recommended after changes are made to any of the underlying base tables.

Example

The following example recompiles scott’s emploc view:

ALTER VIEW scott.emploc RECOMPILE
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset