Skip to content

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

Latest commit

 

History

History
47 lines (39 loc) · 1.81 KB

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

File metadata and controls

47 lines (39 loc) · 1.81 KB

title: "sys.pdw_replicated_table_cache_state (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "07/03/2017" ms.prod: "" ms.prod_service: "sql-data-warehouse" ms.service: "sql-data-warehouse" ms.component: "system-catalog-views" ms.reviewer: "" ms.suite: "sql" ms.technology:

  • "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" dev_langs:
  • "TSQL" author: "ronortloff" ms.author: "rortloff" manager: "craigg" ms.reviewer: "barbkess" ms.workload: "Inactive" 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.