title: "SQL Data Warehouse and Parallel Data Warehouse Catalog Views | Microsoft Docs" ms.custom: "" ms.date: "03/15/2017" ms.prod: "" ms.prod_service: "sql-data-warehouse, pdw" ms.component: "system-catalog-views" ms.reviewer: "" ms.suite: "sql" ms.technology: system-objects ms.tgt_pltfrm: "" ms.topic: "language-reference" dev_langs:
- "TSQL" ms.assetid: ef6f58e2-0162-4bb2-951a-a786da7453e4 caps.latest.revision: 5 aauthor: ronortloff ms.author: rortloff manager: craigg monikerRange: ">= aps-pdw-2016 || = azure-sqldw-latest || = sqlallproducts-allversions"
[!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)