--- title: "DBCC DROPRESULTSETCACHE (Transact-SQL) | Microsoft Docs" 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: XiaoyuL-Preview ms.author: xiaoyul manager: craigg 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 ```sql DBCC DROPRESULTSETCACHE [;] ``` ## Permissions Requires membership in the DB_OWNER fixed server role. ## See also [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.md)
[DBCC SHOWRESULTCACHESPACEUSED (Transact-SQL)](\sql\t-sql\database-console-commands\dbcc-showresultcachespaceused-transact-sql.md)