REFRESH TABLE

The REFRESH TABLE statement refreshes the data in a materialized query table. The statement deletes all rows in the materialized query table and then inserts the result rows from the select-statement specified in the definition of the materialized query table.

For more information, see REFRESH TABLE in the SQL Reference topic in the Information CenterLink to Information center.