Class ObjectSchema.StatsColumn

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.stats_columns (Transact-SQL)

Applies to: √ SQL Server √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics √ Analytics Platform System (PDW) √ SQL analytics endpoint in Microsoft Fabric √ Warehouse in Microsoft Fabric

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

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Extension Methods

Map.DeepCopy<T>(T)

Properties

ColumnID

column_id NULL int

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

object_id NOT NULL int

ID of the object of which this column is part.

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

Property Value

int

StatsColumnID

stats_column_id NULL int

1-based ordinal within set of stats columns.

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

Property Value

int?

StatsID

stats_id NOT NULL int

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