Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
sys.pdw_table_distribution_properties (Transact-SQL)
Applies to: 👁 Image
Azure Synapse Analytics 👁 Image
Analytics Platform System (PDW)
Holds distribution information for tables.
| Column Name | Data Type | Description | Range |
|---|---|---|---|
| object_id | int | ID of the table for which the properties were specified. | |
| distribution_policy | tinyint | 0 = UNDEFINED 1 = NONE 2 = HASH 3 = REPLICATE 4 = ROUND_ROBIN |
|
| distribution_policy_desc | nvarchar(60) | UNDEFINED, NONE, HASH, REPLICATE, ROUND_ROBIN | Azure Synapse Analytics returns either HASH, ROUND_ROBIN or REPLICATE. |
See Also
Azure Synapse Analytics and Parallel Data Warehouse Catalog Views
Feedback
Was this page helpful?