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 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