sys.pdw_column_distribution_properties (Transact-SQL)

APPLIES TO: NoSQL Server NoAzure SQL Database YesAzure Synapse Analytics (SQL DW) 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 = SQL Data Warehouse is using this column to distribute the parent table.

See Also

SQL Data Warehouse and Parallel Data Warehouse Catalog Views