Table of Contents

Class ObjectSchema.FunctionOrderColumn

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

sys.function_order_columns (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Returns one row per column that is a part of an ORDER expression of a common language runtime (CLR) table-valued function.


See sys.function_order_columns.

[Table(Schema = "sys", Name = "function_order_columns", IsView = true)]
public class ObjectSchema.FunctionOrderColumn
Inheritance
ObjectSchema.FunctionOrderColumn
Extension Methods

Properties

ColumnID

ID of the column in object_id.

column_id is unique only within object_id.

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

Property Value

int

IsDescending

1 = order column has a descending sort direction.

0 = order column has an ascending sort direction.

[Column("is_descending")]
[Nullable]
public bool? IsDescending { get; set; }

Property Value

bool?

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 (CLR table-valued function) the order is defined on.

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

Property Value

int

OrderColumnID

ID of the order column. order_column_id is unique only within object_id.

order_column_id represents the position of this column in the ordering.

[Column("order_column_id")]
[NotNull]
public int OrderColumnID { get; set; }

Property Value

int