dbcc-dropresultsetcache-transact-sql.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	dev_langs	monikerRange
DBCC DROPRESULTSETCACHE (Transact-SQL)	DBCC DROPRESULTSETCACHE removes all result set cache entries from an Azure Synapse Analytics database.	mstehrani	emtehran	wiassaf, randolphwest	12/05/2022	sql	data-warehouse	reference	TSQL	= azure-sqldw-latest

DBCC DROPRESULTSETCACHE (Transact-SQL)

[!INCLUDE asa]

Removes all result set cache entries from an [!INCLUDEssazuresynapse-md] database.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

DBCC DROPRESULTSETCACHE
[;]

Note

[!INCLUDEsynapse-analytics-od-unsupported-syntax]

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
  
• ALTER DATABASE SET Options (Transact-SQL)
  
• ALTER DATABASE (Transact-SQL)
  
• SET RESULT SET CACHING (Transact-SQL)
  
• DBCC SHOWRESULTCACHESPACEUSED (Transact-SQL)