sys.pdw_table_distribution_properties (Transact-SQL)
Applies to: Azure Synapse Analytics Analytics Platform System (PDW)
Holds distribution information for tables.
Column Name | Data Type | Description | Range |
---|---|---|---|
object_id | int | ID of the table for which thee 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
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for