Azure Synapse Analytics 和分析平台系統 (PDW) 目錄檢視
適用於:Azure Synapse Analytics Analytics
平台系統 (PDW)
本主題列出 Azure Synapse Analytics 和分析平台系統 (PDW) 目錄檢視。
Azure Synapse Analytics 和分析平台系統 (PDW) 目錄檢視
下列目錄檢視適用於 Azure Synapse Analytics 和分析平台系統 (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 目錄檢視
下列目錄檢視僅適用於 Azure Synapse Analytics:
sys.pdw_materialized_view_column_distribution_properties (Transact-SQL)
sys.pdw_materialized_view_distribution_properties (Transact-SQL)
sys.pdw_materialized_view_mappings (Transact-SQL) (預覽)
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) 目錄檢視
下列目錄檢視僅適用於 Analytics Platform System (PDW) :
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)