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 Center.