หมายเหตุ
การเข้าถึงหน้านี้ต้องได้รับการอนุญาต คุณสามารถลอง ลงชื่อเข้าใช้หรือเปลี่ยนไดเรกทอรีได้
การเข้าถึงหน้านี้ต้องได้รับการอนุญาต คุณสามารถลองเปลี่ยนไดเรกทอรีได้
Applies to: 
Azure Synapse Analytics
Tip
Microsoft Fabric Data Warehouse is an enterprise scale relational warehouse on a data lake foundation, with a future-ready architecture, built-in AI, and new features. If you're new to data warehousing, start with Fabric Data Warehouse. Existing dedicated SQL pool workloads can upgrade to Fabric to access new capabilities across data science, real-time analytics, and reporting.
This article lists the Azure Synapse Analytics catalog views.
| Catalog view | Description |
|---|---|
| sys.pdw_column_distribution_properties | Returns distribution information for columns. |
| sys.pdw_distributions | Holds information about the distributions on the appliance, with one row per appliance distribution. |
| sys.pdw_index_mappings | Maps the logical indexes to the physical name used on Compute nodes. |
| sys.pdw_loader_backup_run_details | Contains detailed information about ongoing and completed backup, restore, and load operations, beyond the information in sys.pdw_loader_backup_runs. |
| sys.pdw_loader_backup_runs | Contains information about ongoing and completed backup, restore, and load operations. |
| sys.pdw_materialized_view_column_distribution_properties | Displays distribution information for columns in a materialized view. |
| sys.pdw_materialized_view_distribution_properties | Displays distribution information for materialized views. |
| sys.pdw_materialized_view_mappings (Preview) | Ties the materialized view to internal object names by object_id. |
| sys.pdw_nodes_column_store_dictionaries | Contains a row for each dictionary used in columnstore indexes. |
| sys.pdw_nodes_column_store_row_groups | Provides clustered columnstore index information on a per-segment basis to help make system management decisions. |
| sys.pdw_nodes_column_store_segments | Contains a row for each column in a columnstore index. |
| sys.pdw_nodes_columns | Shows columns for user-defined tables and user-defined views. |
| sys.pdw_nodes_indexes | Returns indexes for Azure Synapse Analytics. |
| sys.pdw_nodes_partitions | Contains a row for each partition of all the tables and most types of indexes. |
| sys.pdw_nodes_pdw_physical_databases | Contains a row for each physical database on a compute node. |
| sys.pdw_nodes_tables | Contains a row for each table object that a principal either owns or on which the principal has been granted some permission. |
| sys.pdw_permanent_table_mappings | Ties permanent user tables to internal object names by object_id. |
| sys.pdw_replicated_table_cache_state | Returns the state of the cache associated with a replicated table by object_id. |
| sys.pdw_table_distribution_properties | Holds distribution information for tables. |
| sys.pdw_table_mappings | Ties user tables to internal object names by object_id. |
| sys.workload_management_workload_classifier_details | Returns details for each classifier. |
| sys.workload_management_workload_classifiers | Returns details for workload classifiers. |
| sys.workload_management_workload_groups | Returns details for workload groups. |