sp_indexes_100_rowset2 (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_100_rowset2(nvarchar @index_name
, nvarchar @table_schema)

MetaData:

   
create procedure sys.sp_indexes_100_rowset2  
(  
    @index_name     sysname = null,  
    @table_schema   sysname = null     
)  
as  
    select  
        TABLE_CATALOG       = s_iv.TABLE_CATALOG,  
        TABLE_SCHEMA        = s_iv.TABLE_SCHEMA,  
        TABLE_NAME          = s_iv.TABLE_NAME,  
        INDEX_CATALOG       = s_iv.INDEX_CATALOG,  
        INDEX_SCHEMA        = s_iv.INDEX_SCHEMA,  
        INDEX_NAME          = s_iv.INDEX_NAME,  
        PRIMARY_KEY         = s_iv.PRIMARY_KEY,  
        [UNIQUE]            = s_iv.[UNIQUE],  
        [CLUSTERED]         = s_iv.[CLUSTERED],  
        [TYPE]              = s_iv.[TYPE],  
        FILL_FACTOR         = s_iv.FILL_FACTOR,  
        INITIAL_SIZE        = s_iv.INITIAL_SIZE,  
        NULLS               = s_iv.NULLS,  
        SORT_BOOKMARKS      = s_iv.SORT_BOOKMARKS,  
        AUTO_UPDATE         = s_iv.AUTO_UPDATE,  
        NULL_COLLATION      = s_iv.NULL_COLLATION,  
        ORDINAL_POSITION    = s_iv.ORDINAL_POSITION,  
        COLUMN_NAME         = s_iv.COLUMN_NAME,  
        COLUMN_GUID         = s_iv.COLUMN_GUID,  
        COLUMN_PROPID       = s_iv.COLUMN_PROPID,  
        [COLLATION]         = s_iv.[COLLATION],  
        CARDINALITY         = s_iv.CARDINALITY,  
        PAGES               = s_iv.PAGES,  
        FILTER_CONDITION    = s_iv.FILTER_CONDITION,  
        INTEGRATED          = s_iv.INTEGRATED,  
        STATUS              = s_iv.STATUS  
  
    from  
        sys.spt_indexes_view_100 s_iv  
  
    where  
        (@table_schema is null or schema_id(@table_schema) = s_iv.SCHEMA_ID) and  
        (@index_name is null   or @index_name = s_iv.INDEX_NAME)  
  
    order by 8, 10, 4, 5, 6, 17