sys.function_order_columns (Transact-SQL)sys.function_order_columns (Transact-SQL)

適用於: 是SQL Server 否Azure SQL Database 否Azure Synapse Analytics (SQL DW) 否平行處理資料倉儲 APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

傳回一個資料列,每個資料行的一部分順序屬於 common language runtime (CLR) 資料表值函數的運算式。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_idobject_id intint 定義順序所在之物件的識別碼 (CLR 資料表值函式)。ID of the object (CLR table-valued function) the order is defined on.
order_column_idorder_column_id intint 排序資料行的識別碼。ID of the order column. order_column_id只有在是唯一object_idorder_column_id is unique only within object_id.

order_column_id表示此資料行的位置依順序排列。order_column_id represents the position of this column in the ordering.
column_idcolumn_id intint 中的資料行的識別碼object_idID of the column in object_id.

column_id只有在是唯一object_idcolumn_id is unique only within object_id.
is_descendingis_descending bitbit 1 = 排序資料行是以遞減方式排序。1 = order column has a descending sort direction.

0 = 排序資料行是以遞增方式排序。0 = order column has an ascending sort direction.

PermissionsPermissions

目錄檢視內中繼資料的可見性會限制在使用者所擁有的安全性實體,或已授與使用者某些權限的安全性實體。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. 如需相關資訊,請參閱 Metadata Visibility ConfigurationFor more information, see Metadata Visibility Configuration.

另請參閱See Also

物件目錄檢視 (Transact-SQL) Object Catalog Views (Transact-SQL)
目錄檢視 (Transact-SQL)Catalog Views (Transact-SQL)