Table of Contents

Class AzureSynapseAnalyticsSchema.TableDistributionProperty

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.pdw_table_distribution_properties (Transact-SQL)

Applies to: √ Azure Synapse Analytics √ Analytics Platform System (PDW)

Holds distribution information for tables.


See sys.pdw_table_distribution_properties.

[Table(Schema = "sys", Name = "pdw_table_distribution_properties", IsView = true)]
public class AzureSynapseAnalyticsSchema.TableDistributionProperty
Inheritance
AzureSynapseAnalyticsSchema.TableDistributionProperty
Extension Methods

Properties

DistributionPolicy

0 = UNDEFINED

1 = NONE

2 = HASH

3 = REPLICATE

4 = ROUND_ROBIN

[Column("distribution_policy")]
[NotNull]
public byte DistributionPolicy { get; set; }

Property Value

byte

DistributionPolicyDesc

UNDEFINED, NONE, HASH, REPLICATE, ROUND_ROBIN
Range: Azure Synapse Analytics returns either HASH, ROUND_ROBIN or REPLICATE.

[Column("distribution_policy_desc")]
[NotNull]
public string DistributionPolicyDesc { get; set; }

Property Value

string

Object

objects (sys.objects)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = false)]
public ObjectSchema.Object Object { get; set; }

Property Value

ObjectSchema.Object

ObjectID

ID of the table for which thee properties were specified.

[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

Property Value

int