Drops a precomputed result set.
drop {precomputed result set | materialized view}
[owner_name.]prs_name
drops a materialized view or precomputed result set.
name of the precomputed result set. A fully qualified prs_name cannot include the server or database name.
Drops the authors_prs precomputed result set:
drop precomputed result set authors_prs
The drop precomputed result set command is a Transact-SQL extension and is not covered by the SQL standard.
You must be the precomputed result set owner.
Dropping precomputed result sets is not audited.
