sys.function_order_columns (Transact-SQL)
Returns one row per column that is a part of an ORDER expression of a commmon 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
In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.
Change History
Updated content |
|---|
Changed the data type for the is_descending column to bit. |