Class ObjectSchema.StatsColumn

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.stats_columns (Transact-SQL)

Applies to: √ SQL Server (all supported versions) √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics √ Analytics Platform System (PDW)

Contains a row for each column that is part of sys.stats statistics.

See sys.stats_columns.

[Table(Schema = "sys", Name = "stats_columns", IsView = true)]
public class ObjectSchema.StatsColumn

Inheritance

object

ObjectSchema.StatsColumn

Extension Methods

Map.DeepCopy<T>(T)

Properties

ColumnID

ID of the column from sys.columns.

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

Property Value

int?

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 of which this column is part.

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

Property Value

int

StatsColumnID

1-based ordinal within set of stats columns.

[Column("stats_column_id")]
[Nullable]
public int? StatsColumnID { get; set; }

Property Value

int?

StatsID

ID of the statistics of which this column is part.

If statistics correspond to an index, the stats_id value is the same as the index_id value in the sys.indexes catalog view.

[Column("stats_id")]
[NotNull]
public int StatsID { get; set; }

Property Value

int