sys.pdw_table_distribution_properties (Transact-SQL)

APPLIES TO: noSQL Server noAzure SQL Database yesAzure Synapse Analytics (SQL DW) yesParallel Data Warehouse

Holds distribution information for tables.

Column Name Data Type Description Range
object_id int ID of the table for which thee properties were specified.
distribution_policy tinyint 0 = UNDEFINED

1 = NONE

2 = HASH

3 = REPLICATE

4 = ROUND_ROBIN
distribution_policy_desc nvarchar(60) UNDEFINED, NONE, HASH, REPLICATE, ROUND_ROBIN SQL Data Warehouse returns either HASH, ROUND_ROBIN or REPLICATE.

See Also

SQL Data Warehouse and Parallel Data Warehouse Catalog Views