分享方式:


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)

另請參閱

目錄檢視 (Transact-SQL)