refresh

Description

Refreshes the specified precomputed result set.

Syntax

refresh precomputed result set prs_name 

Parameters

prs_name

name of the precomputed result set. A fully qualified prs_name cannot include the server or database name.

Examples

Example 1

Refreshes the au_prs precomputed result set:

refresh precomputed result set au_prs

Usage

Standards

The refresh precomputed result set command is a Transact-SQL extension and is not covered by the SQL standard.

Permissions

You must have create table privilege to refresh precomputed result sets.

Auditing

Refreshing precomputed result sets is not audited.