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