Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to: 
Azure Synapse Analytics
Ties the materialized view to internal object names by object_id.
The columns physical_name and object_id form the key for this catalog view.
| Column Name | Data Type | Description |
|---|---|---|
| physical_name | nvarchar(36) | The physical name for the materialized view. |
| object_id | int | The object ID for the materialized view. See sys.objects (Transact-SQL). |
Permissions
Requires VIEW DATABASE STATE permission.
See also
Performance tuning with Materialized View
CREATE MATERIALIZED VIEW AS SELECT (Transact-SQL)
ALTER MATERIALIZED VIEW (Transact-SQL)
EXPLAIN (Transact-SQL)
sys.pdw_materialized_view_column_distribution_properties (Transact-SQL)
sys.pdw_materialized_view_distribution_properties (Transact-SQL)
DBCC PDW_SHOWMATERIALIZEDVIEWOVERHEAD (Transact-SQL)
Azure Synapse Analytics and Parallel Data Warehouse Catalog Views
System views supported in Azure Synapse Analytics
T-SQL statements supported in Azure Synapse Analytics