title

sys.function_order_columns (Transact-SQL)

description

sys.function_order_columns (Transact-SQL)

author

rwestMSFT

ms.author

randolphwest

ms.date

06/10/2016

ms.service

sql

ms.subservice

system-objects

ms.topic

reference

f1_keywords

function_order_columns

sys.function_order_columns_TSQL

function_order_columns_TSQL

sys.function_order_columns

helpviewer_keywords

sys.function_order_columns catalog view

dev_langs

TSQL

sys.function_order_columns (Transact-SQL)

[!INCLUDE SQL Server]

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

Column name	Data type	Description
object_id	int	ID of the object (CLR table-valued function) the order is defined on.
order_column_id	int	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_id	int	ID of the column in object_id. column_id is unique only within object_id.
is_descending	bit	1 = order column has a descending sort direction. 0 = order column has an ascending sort direction.

Permissions