Refreshes the specified precomputed result set.
refresh precomputed result set prs_name
name of the precomputed result set. A fully qualified prs_name cannot include the server or database name.
Refreshes the au_prs precomputed result set:
refresh precomputed result set au_prs
refresh precomputed result set permission defaults to the precomputed result set owner and can be transferred to other users.
The refresh precomputed result set command is a Transact-SQL extension and is not covered by the SQL standard.
You must have create table privilege to refresh precomputed result sets.
Refreshing precomputed result sets is not audited.