Azure Synapse Analytics 和并行数据仓库目录视图

适用于: 是Azure Synapse Analytics 是并行数据仓库

本主题列出 和 Azure Synapse Analytics Analytics Platform System (PDW) 目录视图。

Azure Synapse Analytics 和 Analytics Platform System (PDW) 目录视图

以下目录视图适用于 和 Azure Synapse Analytics 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 目录视图

以下目录视图仅适用于 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)