Class AzureSynapseAnalyticsSchema.MaterializedViewColumnDistributionProperty

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.pdw_materialized_view_column_distribution_properties (Transact-SQL)

Applies to: √ Azure Synapse Analytics

Displays distribution information for columns in a materialized view.

See sys.pdw_materialized_view_column_distribution_properties.

[Table(Schema = "sys", Name = "pdw_materialized_view_column_distribution_properties", IsView = true)]
public class AzureSynapseAnalyticsSchema.MaterializedViewColumnDistributionProperty

Inheritance

object

AzureSynapseAnalyticsSchema.MaterializedViewColumnDistributionProperty

Extension Methods

Map.DeepCopy<T>(T)

Properties

ColumnID

The ID of the column.

[Column("column_id")]
[NotNull]
public int ColumnID { get; set; }

Property Value

int

DistributionOrdinal

0 = Not a distribution column.
1 = Azure Synapse Analytics is using this column to distribute the materialized view.

[Column("distribution_ordinal")]
[NotNull]
public byte DistributionOrdinal { get; set; }

Property Value

byte

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 object to which the column belongs.

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

Property Value

int