--- title: Catalog Views titleSuffix: Azure Synapse Analytics and Analytics Platform System (PDW) description: Azure Synapse Analytics and Analytics Platform System (PDW) catalog views author: WilliamDAssafMSFT ms.author: wiassaf ms.date: 05/25/2022 ms.prod: sql ms.prod_service: "synapse-analytics, pdw" ms.technology: system-objects ms.topic: language-reference ms.custom: seo-dt-2019 dev_langs: - "TSQL" monikerRange: ">=aps-pdw-2016||=azure-sqldw-latest" --- # Azure Synapse Analytics and Analytics Platform System (PDW) 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)