refresh precomputed result set

Refreshes the specified precomputed result set.

Syntax

refresh precomputed result set prs_name 

Parameters

Examples

Usage

refresh precomputed result set permission defaults to the precomputed result set owner and can be transferred to other users.

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.