Azure Synapse Analytics and Analytics Platform System (PDW) catalog views
Applies to: Azure Synapse Analytics Analytics Platform System (PDW)
This topic lists the Azure Synapse Analytics and Analytics Platform System (PDW) catalog views.
Azure Synapse Analytics and Analytics Platform System (PDW) catalog views
The following catalog views apply to both Azure Synapse Analytics and Analytics Platform System (PDW):
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)
Azure Synapse Analytics catalog views
The following catalog views apply to Azure Synapse Analytics only:
sys.pdw_materialized_view_column_distribution_properties (Transact-SQL)
sys.pdw_materialized_view_distribution_properties (Transact-SQL)
sys.pdw_materialized_view_mappings (Transact-SQL) (Preview)
sys.pdw_permanent_table_mappings (Transact-SQL)
sys.workload_management_workload_classifier_details (Transact-SQL)
sys.workload_management_workload_classifiers (Transact-SQL)
sys.workload_management_workload_groups (Transact-SQL)
Analytics Platform System (PDW) catalog views
The following catalog views apply to Analytics Platform System (PDW) 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)
sys.pdw_loader_run_stages (Transact-SQL)
See also
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: Under hela 2024 kommer vi att fasa ut GitHub-problem som feedbackmekanism för innehåll och ersätta det med ett nytt feedbacksystem. Mer information finns i:Skicka och visa feedback för