VIEW: SYS.KU$_TABCLUSTER_VIEW

Source

View Text - Preformatted

select t.obj#,
         value(cl),
         cast(multiset(select * from ku$_tabcluster_col_view c
                       where c.obj_num = t.obj#
                        order by c.segcol_num
                      ) as ku$_simple_col_list_t
             )
  from  ku$_schemaobj_view cl, sys.tab$ t
  where bitand(t.property,1024) = 1024          -- clustered table
    and cl.obj_num = t.bobj#

View Text - HTML Formatted

SELECT T.OBJ#
, VALUE(CL)
, CAST(MULTISET(SELECT *
FROM KU$_TABCLUSTER_COL_VIEW C
WHERE C.OBJ_NUM = T.OBJ# ORDER BY C.SEGCOL_NUM ) AS KU$_SIMPLE_COL_LIST_T )
FROM KU$_SCHEMAOBJ_VIEW CL
, SYS.TAB$ T
WHERE BITAND(T.PROPERTY
, 1024) = 1024 -- CLUSTERED TABLE
AND CL.OBJ_NUM = T.BOBJ#