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
Povratne informacije
https://aka.ms/ContentUserFeedback.
Stiže uskoro: Tokom 2024. godine postepeno ćemo ukidati probleme sa uslugom GitHub kao mehanizam povratnih informacija za sadržaj i zameniti ga novim sistemom povratnih informacija. Dodatne informacije potražite u članku:Prosledite i prikažite povratne informacije za