| title | SQL Data Warehouse and Parallel Data Warehouse Catalog Views | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/15/2017 | |
| ms.prod | sql-non-specified | |
| ms.reviewer | ||
| ms.suite | ||
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | language-reference | |
| dev_langs |
|
|
| ms.assetid | ef6f58e2-0162-4bb2-951a-a786da7453e4 | |
| caps.latest.revision | 5 | |
| author | barbkess | |
| ms.author | barbkess | |
| manager | jhubbard |
[!INCLUDEtsql-appliesto-xxxxxx-xxxx-asdw-pdw_md]
This topic lists the [!INCLUDEssSDW] and [!INCLUDEssPDW] catalog views.
All [!INCLUDEssSDW] and [!INCLUDEssPDW] catalog views begin with sys.pdw.
The following catalog views apply to both [!INCLUDEssSDW] and [!INCLUDEssPDW]:
sys.pdw_column_distribution_properties (Transact-SQL)
sys.pdw_database_mappings (Transact-SQL)
sys.pdw_distributions (Transact-SQL)
sys.pdw_index_mappings (Transact-SQL)
sys.pdw_loader_backup_run_details (Transact-SQL)
sys.pdw_loader_backup_runs (Transact-SQL)
sys.pdw_nodes_column_store_dictionaries (Transact-SQL)
sys.pdw_nodes_column_store_row_groups (Transact-SQL)
sys.pdw_nodes_column_store_segments (Transact-SQL)
sys.pdw_nodes_columns (Transact-SQL)
sys.pdw_nodes_indexes (Transact-SQL)
sys.pdw_nodes_partitions (Transact-SQL)
sys.pdw_nodes_pdw_physical_databases (Transact-SQL)
sys.pdw_nodes_tables (Transact-SQL)
sys.pdw_replicated_table_cache_state (Transact-SQL)
sys.pdw_table_distribution_properties (Transact-SQL)
sys.pdw_table_mappings (Transact-SQL)
[!INCLUDEssPDW] Catalog Views
The following catalog views apply to [!INCLUDEssPDW] only:
sys.pdw_diag_event_properties (Transact-SQL)
sys.pdw_diag_events (Transact-SQL)
sys.pdw_diag_sessions (Transact-SQL)
sys.pdw_health_alerts (Transact-SQL)
sys.pdw_health_component_groups (Transact-SQL)
sys.pdw_health_component_properties (Transact-SQL)
sys.pdw_health_component_status_mappings (Transact-SQL)
sys.pdw_health_components (Transact-SQL)