| title | sys.pdw_column_distribution_properties (Transact-SQL) | |
|---|---|---|
| description | The sys.pdw_column_distribution_properties system catalog view returns distribution information for columns. | |
| author | WilliamDAssafMSFT | |
| ms.author | wiassaf | |
| ms.reviewer | wiassaf | |
| ms.date | 07/25/2022 | |
| ms.service | sql | |
| ms.subservice | data-warehouse | |
| ms.topic | reference | |
| dev_langs |
|
|
| monikerRange | >=aps-pdw-2016||=azure-sqldw-latest |
[!INCLUDEapplies-to-version/asa-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: [!INCLUDEssazuresynapse-md] is using this column to distribute the parent table. |