Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todaysys.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. |