Bilješka
Pristup ovoj stranici zahtijeva provjeru vjerodostojnosti. Možete pokušati da se prijavite ili promijenite direktorije.
Pristup ovoj stranici zahtijeva provjeru vjerodostojnosti. Možete pokušati promijeniti direktorije.
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.
Related content
- 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) (preview)
- DBCC PDW_SHOWMATERIALIZEDVIEWOVERHEAD (Transact-SQL)
- Azure Synapse Analytics and Analytics Platform System (PDW) catalog views
- System views supported in Azure Synapse Analytics
- T-SQL statements supported in Azure Synapse Analytics