--- 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) [!INCLUDE[tsql-appliesto-xxxxxx-xxxx-asdw-xxx-md](../../includes/tsql-appliesto-xxxxxx-xxxx-asdw-xxx-md.md)] Removes all result set cache entries from an Azure [!INCLUDE[ssSDW](../../includes/sssdw-md.md)] database. ![Topic link icon](../../database-engine/configure-windows/media/topic-link.gif "Topic link icon") [Transact-SQL Syntax Conventions (Transact-SQL)](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md) ## Syntax ```syntaxsql 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 - [Performance tuning with result set caching](/azure/sql-data-warehouse/performance-tuning-result-set-caching)
- [ALTER DATABASE SET Options (Transact-SQL)](/sql/t-sql/statements/alter-database-transact-sql-set-options?view=azure-sqldw-latest)
- [ALTER DATABASE (Transact-SQL)](/sql/t-sql/statements/alter-database-transact-sql?view=azure-sqldw-latest)
- [SET RESULT SET CACHING (Transact-SQL)](/sql/t-sql/statements/set-result-set-caching-transact-sql)
- [DBCC SHOWRESULTCACHESPACEUSED (Transact-SQL)](/sql/t-sql/database-console-commands/dbcc-showresultcachespaceused-transact-sql)