sys-pdw-replicated-table-cache-state-transact-sql.md

title	sys.pdw_replicated_table_cache_state (Transact-SQL)
ms.custom	seo-dt-2019
ms.date	07/03/2017
ms.prod	sql
ms.technology	data-warehouse
ms.reviewer
ms.topic	language-reference
dev_langs	TSQL
author	ronortloff
ms.author	rortloff
monikerRange	= azure-sqldw-latest || = sqlallproducts-allversions

sys.pdw_replicated_table_cache_state (Transact-SQL)

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

Returns the state of the cache associated with a replicated table by object_id.

Column Name	Data Type	Description	Range
object_id	int	The object ID for the table. See sys.objects (Transact-SQL). object_id is the key for this view.
state	nvarchar(40)	The replicated table cache state for this table.	'NotReady','Ready'

Example

This example joins sys.pdw_replicated_table_cache_state with sys.tables to retrieve the table name and the state of the replicated table cache.

SELECT t.[name], p.[object_id], p.[state]
  FROM sys.pdw_replicated_table_cache_state p 
  JOIN sys.tables t ON t.object_id = p.object_id

Next steps

For a list of all the catalog views for SQL Data Warehouse and Parallel Data Warehouse, see SQL Data Warehouse and Parallel Data Warehouse Catalog Views.