Skip to main content

REFRESH VIEW

Refreshes the data in a materialized view within a session.

See also:
[ CREATE ] [ DROP ]


Syntax

refreshViewStatement::=

REFRESHMATERIALIZEDVIEWviewName';'

 

REFRESH MATERIALIZED VIEW <viewName>;

Examples

Refresh a Materialized View

REFRESH MATERIALIZED VIEW vw_ec2_instance_types;