Sybase Adaptive Server Anywhere - SYSINDEXES System View

Chapter 16 System Views
1061
SYSINDEXES system view
CREATE VIEW SYS.SYSINDEXES ( icreator, iname, fname,
creator,
tname, indextype, colnames, interval, level )
AS
SELECT ( SELECT user_name FROM SYS.SYSUSERPERM
WHERE user_id = SYSINDEX.creator ),
index_name,
( SELECT file_name FROM SYS.SYSFILE
WHERE file_id = SYSINDEX.file_id ),
( SELECT user_name FROM SYS.SYSUSERPERM
WHERE user_id = SYSINDEX.creator ),
table_name,
IF "unique" = ’Y’ THEN ’Unique’
ELSE ’Non-unique’ ENDIF,
( SELECT list( string( column_name,
IF "order" = ’A’ THEN ’ ASC’ i
ELSE ’ DESC’ ENDIF ) )
FROM SYS.SYSIXCOL == SYS.SYSCOLUMN
WHERE index_id = SYSINDEX.index_id ), 0, 0
FROM SYS.SYSTABLE KEY JOIN SYS.SYSINDEX
Presents index information from SYSINDEX and SYSIXCOL in a more
readable format.