Skip to content

Latest commit

 

History

History
34 lines (29 loc) · 1.29 KB

File metadata and controls

34 lines (29 loc) · 1.29 KB
title sys.pdw_column_distribution_properties (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 03/03/2017
ms.prod sql-non-specified
ms.reviewer
ms.suite
ms.technology
database-engine
ms.tgt_pltfrm
ms.topic language-reference
dev_langs
TSQL
ms.assetid 46b74f99-2e22-4dbd-872a-533fce0e239c
caps.latest.revision 5
author barbkess
ms.author barbkess
manager jhubbard

sys.pdw_column_distribution_properties (Transact-SQL)

[!INCLUDEtsql-appliesto-xxxxxx-xxxx-asdw-pdw_md]

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 = [!INCLUDEssSDW] is using this column to distribute the parent table.

See Also

SQL Data Warehouse and Parallel Data Warehouse Catalog Views