select u.user_name,
t.table_name,
t.table_id,
i.index_name,
i.index_id,
i."unique",
DT.cols, 
DT.seqs, 
DT.rev_seqs
from SYS.SYSINDEX i 
join SYS.SYSTABLE t on (t.table_id=i.table_id)
join SYS.SYSUSERPERMS u on (u.user_id=t.creator),
lateral (select list(c.column_name order by ixc.sequence), 
list(ixc."order" order by ixc.sequence),
list( (if ixc."order" ='A' then 'D' else 'A' endif) order by ixc.sequence)
from SYS.SYSIXCOL ixc 
join SYS.SYSCOLUMN c
on (c.column_id=ixc.column_id and c.table_id=ixc.table_id)
where ixc.table_id=i.table_id
and ixc.index_id=i.index_id
) as DT( cols, seqs, rev_seqs)
where i.creator <>  0