SELECT TABLE_SCHEMA,TABLE_NAME,TABLE_ID
FROM MASTER.SQL_TABLES WHERE N_INDEX >= 1
SELECT TABLE_SCHEMA,TABLE_NAME,INDEX_NAME,INDEX_ID,COLUMN_NAME
FROM MASTER.SQL_INDEX_COLINF
WHERE TABLE_SCHEMA = USER
SELECT X.TABLE_SCHEMA,X.TABLE_NAME,X.TABLE_ID,
INDEX_ID,COLUMN_NAME
FROM MASTER.SQL_TABLES X,MASTER.SQL_INDEX_COLINF Y
WHERE X.TABLE_SCHEMA = Y.TABLE_SCHEMA
AND X.TABLE_SCHEMA = USER
AND X.TABLE_NAME = Y.TABLE_NAME
AND N_INDEX >= 1