Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
sys.pdw_replicated_table_cache_state (Transact-SQL)
Applies to: 👁 Image
Azure Synapse Analytics
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 Azure Synapse Analytics and Parallel Data Warehouse, see Azure Synapse Analytics and Parallel Data Warehouse Catalog Views.
Feedback
Was this page helpful?