sys.pdw_column_distribution_properties (Transact-SQL)

Applies to: Azure Synapse Analytics Analytics Platform System (PDW)

Returns distribution information for columns.

Column Name Data Type Description Range
object_id int ID of the object to which the column belongs.
column_id int ID of the column.
distribution_ordinal tinyint Ordinal (1-based) within set of distribution. = 0: Not a distribution column.

= 1 or >1: Azure Synapse Analytics is using this column to distribute the parent table.

Next steps