| title | Catalog Views | |
|---|---|---|
| titleSuffix | Azure SQL Data Warehouse and Parallel Data Warehouse | |
| ms.date | 10/29/2019 | |
| ms.service | sql-data-warehouse | |
| ms.reviewer | jrasnick | |
| ms.topic | language-reference | |
| dev_langs |
|
|
| ms.assetid | ef6f58e2-0162-4bb2-951a-a786da7453e4 | |
| author | julieMSFT | |
| ms.author | jrasnick | |
| monikerRange | >= aps-pdw-2016 || = azure-sqldw-latest || = sqlallproducts-allversions | |
| ms.custom | seo-dt-2019 |
[!INCLUDEtsql-appliesto-xxxxxx-xxxx-asdw-pdw-md]
This topic lists the [!INCLUDEssSDW] and [!INCLUDEssPDW] catalog views.
The following catalog views apply to both [!INCLUDEssSDW] and [!INCLUDEssPDW]:
sys.pdw_column_distribution_properties (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)
[!INCLUDEssSDW] Catalog Views
The following catalog views apply to [!INCLUDEssSDW] only:
sys.pdw_materialized_view_column_distribution_properties (Transact-SQL) (Preview)
sys.pdw_materialized_view_distribution_properties (Transact-SQL) (Preview)
sys.pdw_materialized_view_mappings (Transact-SQL) (Preview)
sys.workload_management_workload_classifier_details (Transact-SQL)
sys.workload_management_workload_classifiers (Transact-SQL)
sys.workload_management_workload_groups (Transact-SQL) (Preview)
[!INCLUDEssPDW] Catalog Views
The following catalog views apply to [!INCLUDEssPDW] only:
sys.pdw_database_mappings (Transact-SQL)
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)