drop precomputed result set

Syntax

drop {precomputed result set | materialized view}
	[owner_name.]prs_name

Parameters

• materialized view | precomputed result set – drops a materialized view or precomputed result set.
• prs_name – name of the precomputed result set. A fully qualified prs_name cannot include the server or database name.

Examples

• Example 1 – Drops the authors_prs precomputed result set:

  drop precomputed result set authors_prs

Standards

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

Permissions

You must be the precomputed result set owner.

Auditing

Dropping precomputed result sets is not audited.