Skip to content

dbcc-dropresultsetcache-transact-sql.md

Latest commit

 

History

History
50 lines (36 loc) · 1.86 KB

dbcc-dropresultsetcache-transact-sql.md

File metadata and controls

50 lines (36 loc) · 1.86 KB
title DBCC DROPRESULTSETCACHE (Transact-SQL)
ms.custom
ms.date 07/03/2019
ms.prod sql
ms.technology data-warehouse
ms.reviewer
ms.topic language-reference
dev_langs
TSQL
ms.assetid 73f598cf-b02a-4dba-8d89-9fc0b55a12b8
author XiaoyuMSFT
ms.author xiaoyul
monikerRange = azure-sqldw-latest || = sqlallproducts-allversions

DBCC DROPRESULTSETCACHE (Transact-SQL)

[!INCLUDEtsql-appliesto-xxxxxx-xxxx-asdw-xxx-md]

Removes all result set cache entries from an Azure [!INCLUDEssSDW] database.

Topic link icon Transact-SQL Syntax Conventions (Transact-SQL)

Syntax

DBCC DROPRESULTSETCACHE
[;]

Permissions

Requires membership in the DB_OWNER fixed server role.

Remarks

  • This command empties the result set cache for all queries.

  • Turning OFF the result set cache feature for a database also deletes all cached results.

  • Pausing a database enabled with result set caching won't delete the cached results.

See also