sp_indexes_90_rowset_rmt (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
The meta data is from an SQL 2012 Server.

I have posted alot more, find the whole list here.

Goto Definition or MetaData

Definition:

sys.sp_indexes_90_rowset_rmt(nvarchar @table_server
, nvarchar @table_catalog
, nvarchar @table_name
, nvarchar @index_name
, nvarchar @table_schema)

MetaData:

   
create procedure sys.sp_indexes_90_rowset_rmt  
(  
    @table_server       sysname,  
    @table_catalog      sysname = null,  
    @table_name         sysname = null,  
    @index_name         sysname = null,  
    @table_schema       sysname = null  
)  
as  
    select  
        TABLE_CATALOG,  
        TABLE_SCHEMA,  
        TABLE_NAME,  
        INDEX_CATALOG,  
        INDEX_SCHEMA,  
        INDEX_NAME,  
        PRIMARY_KEY,  
        [UNIQUE],  
        [CLUSTERED],  
        [TYPE],  
        FILL_FACTOR,  
        INITIAL_SIZE,  
        NULLS,  
        SORT_BOOKMARKS,  
        AUTO_UPDATE,  
        NULL_COLLATION,  
        ORDINAL_POSITION,  
        COLUMN_NAME,  
        COLUMN_GUID,  
        COLUMN_PROPID,  
        [COLLATION],  
        CARDINALITY,  
        PAGES,  
        FILTER_CONDITION,  
        INTEGRATED = null,  --  ISSUE these 3 columns must be exported by the server  
                            --  in \yukon\sql\ntdbms\msql\ddl\sysoledb.cpp :  
                            --  const SCHEMA_COLUMNS xCol_INDEXES = {  
        STATUS = 0          --  ISSUE - to be changed to FT_KEY (type BIT)  
  
    from  
         sys.fn_remote_indexes (  
                @table_server,  
                @table_catalog,  
                @table_schema,  
                @index_name,  
                null,           --  TYPE (index type)  
                @table_name )  
    order by 8 desc, 4, 5, 6, 17