sys.pdw_column_distribution_properties (Transact-SQL)

Applies to: yesAzure Synapse Analytics yesParallel Data Warehouse

Holds 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 = Azure Synapse Analytics is using this column to distribute the parent table.

See Also

Azure Synapse Analytics and Parallel Data Warehouse Catalog Views