SQL Reference

REFRESH TABLE

The REFRESH TABLE statement refreshes the data in a summary table.

Invocation

This statement can be embedded in an application program or issued through the use of dynamic SQL statements. It is an executable statement that can be dynamically prepared.

Authorization

The privileges held by the authorization ID of the statement must include at least one of the following:

• SYSADM or DBADM authority
• CONTROL privilege on the table.

Syntax

                   .-,-------------.
                   V               |
>>-REFRESH--TABLE-----table-name---+---------------------------><
 

Description

table-name

Specifies a table name.

The name, including the implicit or explicit schema, must identify a table that already exists at the current server. The table must allow the REFRESH TABLE statement (SQLSTATE 42809). This includes summary tables defined with:

• REFRESH IMMEDIATE
• REFRESH DEFERRED