sys.pdw_replicated_table_cache_state (Transact-SQL)

THIS TOPIC APPLIES TO: noSQL Server (starting with 2008)noAzure SQL DatabaseyesAzure SQL Data Warehouse noParallel Data Warehouse

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'


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.