| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.function_order_columns (Transact-SQL) |
sys.function_order_columns (Transact-SQL) |
rwestMSFT |
randolphwest |
06/10/2016 |
sql |
system-objects |
reference |
|
|
|
[!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. |
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.
Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)