--- description: "Azure Synapse Analytics and Parallel Data Warehouse Catalog Views" title: Catalog Views titleSuffix: Azure Synapse Analytics and Parallel Data Warehouse ms.date: 10/29/2019 ms.service: sql-data-warehouse ms.reviewer: jrasnick ms.topic: language-reference dev_langs: - "TSQL" ms.assetid: ef6f58e2-0162-4bb2-951a-a786da7453e4 author: julieMSFT ms.author: jrasnick monikerRange: ">= aps-pdw-2016 || = azure-sqldw-latest" ms.custom: seo-dt-2019 --- # Azure Synapse Analytics and Parallel Data Warehouse Catalog Views [!INCLUDE[applies-to-version/asa-pdw](../../includes/applies-to-version/asa-pdw.md)] This topic lists the [!INCLUDE[ssSDW](../../includes/sssdw-md.md)] and [!INCLUDE[ssPDW](../../includes/sspdw-md.md)] catalog views. ## [!INCLUDE[ssSDW](../../includes/sssdw-md.md)] and [!INCLUDE[ssPDW](../../includes/sspdw-md.md)] Catalog Views The following catalog views apply to both [!INCLUDE[ssSDW](../../includes/sssdw-md.md)] and [!INCLUDE[ssPDW](../../includes/sspdw-md.md)]: [sys.pdw_column_distribution_properties (Transact-SQL)](../../relational-databases/system-catalog-views/sys-pdw-column-distribution-properties-transact-sql.md) [sys.pdw_distributions (Transact-SQL)](../../relational-databases/system-catalog-views/sys-pdw-distributions-transact-sql.md) [sys.pdw_index_mappings (Transact-SQL)](../../relational-databases/system-catalog-views/sys-pdw-index-mappings-transact-sql.md) [sys.pdw_loader_backup_run_details (Transact-SQL)](../../relational-databases/system-catalog-views/sys-pdw-loader-backup-run-details-transact-sql.md) [sys.pdw_loader_backup_runs (Transact-SQL)](../../relational-databases/system-catalog-views/sys-pdw-loader-backup-runs-transact-sql.md) [sys.pdw_nodes_column_store_dictionaries (Transact-SQL)](../../relational-databases/system-catalog-views/sys-pdw-nodes-column-store-dictionaries-transact-sql.md) [sys.pdw_nodes_column_store_row_groups (Transact-SQL)](../../relational-databases/system-catalog-views/sys-pdw-nodes-column-store-row-groups-transact-sql.md) [sys.pdw_nodes_column_store_segments (Transact-SQL)](../../relational-databases/system-catalog-views/sys-pdw-nodes-column-store-segments-transact-sql.md) [sys.pdw_nodes_columns (Transact-SQL)](../../relational-databases/system-catalog-views/sys-pdw-nodes-columns-transact-sql.md) [sys.pdw_nodes_indexes (Transact-SQL)](../../relational-databases/system-catalog-views/sys-pdw-nodes-indexes-transact-sql.md) [sys.pdw_nodes_partitions (Transact-SQL)](../../relational-databases/system-catalog-views/sys-pdw-nodes-partitions-transact-sql.md) [sys.pdw_nodes_pdw_physical_databases (Transact-SQL)](../../relational-databases/system-catalog-views/sys-pdw-nodes-pdw-physical-databases-transact-sql.md) [sys.pdw_nodes_tables (Transact-SQL)](../../relational-databases/system-catalog-views/sys-pdw-nodes-tables-transact-sql.md) [sys.pdw_replicated_table_cache_state (Transact-SQL)](sys-pdw-replicated-table-cache-state-transact-sql.md) [sys.pdw_table_distribution_properties (Transact-SQL)](../../relational-databases/system-catalog-views/sys-pdw-table-distribution-properties-transact-sql.md) [sys.pdw_table_mappings (Transact-SQL)](../../relational-databases/system-catalog-views/sys-pdw-table-mappings-transact-sql.md) ## [!INCLUDE[ssSDW](../../includes/sssdw-md.md)] Catalog Views The following catalog views apply to [!INCLUDE[ssSDW](../../includes/sssdw-md.md)] only: [sys.pdw_materialized_view_column_distribution_properties (Transact-SQL)](./sys-pdw-materialized-view-column-distribution-properties-transact-sql.md?view=azure-sqldw-latest&preserve-view=true) [sys.pdw_materialized_view_distribution_properties (Transact-SQL)](./sys-pdw-materialized-view-distribution-properties-transact-sql.md?view=azure-sqldw-latest&preserve-view=true) [sys.pdw_materialized_view_mappings (Transact-SQL)](./sys-pdw-materialized-view-mappings-transact-sql.md?view=azure-sqldw-latest&preserve-view=true) (Preview) [sys.pdw_permanent_table_mappings (Transact-SQL)](../../relational-databases/system-catalog-views/sys-pdw-permanent-table-mappings-transact-sql.md) [sys.workload_management_workload_classifier_details (Transact-SQL)](../../relational-databases/system-catalog-views/sys-workload-management-workload-classifier-details-transact-sql.md) [sys.workload_management_workload_classifiers (Transact-SQL)](../../relational-databases/system-catalog-views/sys-workload-management-workload-classifiers-transact-sql.md) [sys.workload_management_workload_groups (Transact-SQL)](./sys-workload-management-workload-groups-transact-sql.md?view=azure-sqldw-latest&preserve-view=true) ## [!INCLUDE[ssPDW](../../includes/sspdw-md.md)] Catalog Views The following catalog views apply to [!INCLUDE[ssPDW](../../includes/sspdw-md.md)] only: [sys.pdw_database_mappings (Transact-SQL)](../../relational-databases/system-catalog-views/sys-pdw-database-mappings-transact-sql.md) [sys.pdw_diag_event_properties (Transact-SQL)](../../relational-databases/system-catalog-views/sys-pdw-diag-event-properties-transact-sql.md) [sys.pdw_diag_events (Transact-SQL)](../../relational-databases/system-catalog-views/sys-pdw-diag-events-transact-sql.md) [sys.pdw_diag_sessions (Transact-SQL)](../../relational-databases/system-catalog-views/sys-pdw-diag-sessions-transact-sql.md) [sys.pdw_health_alerts (Transact-SQL)](../../relational-databases/system-catalog-views/sys-pdw-health-alerts-transact-sql.md) [sys.pdw_health_component_groups (Transact-SQL)](../../relational-databases/system-catalog-views/sys-pdw-health-component-groups-transact-sql.md) [sys.pdw_health_component_properties (Transact-SQL)](../../relational-databases/system-catalog-views/sys-pdw-health-component-properties-transact-sql.md) [sys.pdw_health_component_status_mappings (Transact-SQL)](../../relational-databases/system-catalog-views/sys-pdw-health-component-status-mappings-transact-sql.md) [sys.pdw_health_components (Transact-SQL)](../../relational-databases/system-catalog-views/sys-pdw-health-components-transact-sql.md) [sys.pdw_loader_run_stages (Transact-SQL)](../../relational-databases/system-catalog-views/sys-pdw-loader-run-stages-transact-sql.md) ## See Also [Catalog Views (Transact-SQL)](../../relational-databases/system-catalog-views/catalog-views-transact-sql.md)