Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Azure Synapse Analytics
Displays distribution information materialized views.
| Column Name | Data Type | Description |
|---|---|---|
| object_id | int | ID of the materialized view for which the properties were specified. |
| distribution_policy | tinyint | 2 = HASH 4 = ROUND_ROBIN |
| distribution_policy_desc | nvarchar(60) | HASH, ROUND_ROBIN |
Permissions
Requires VIEW DATABASE STATE permission.
Related content
- CREATE MATERIALIZED VIEW AS SELECT (Transact-SQL)
- ALTER MATERIALIZED VIEW (Transact-SQL)
- EXPLAIN (Transact-SQL)
- sys.pdw_materialized_view_mappings (Transact-SQL)
- 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