sys.pdw_materialized_view_mappings (Transact-SQL)
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