--> How to find out list of indexes in Teradata?

SELECT
databasename, tablename, columnname, indextype, indexnumber, indexname
FROM 
dbc.indices
ORDER BY
databasename, tablename, indexnumber;

IndexType Description
P Nonpartitioned Primary
Q Partitioned Primary
S Secondary
J join index
N hash index
K primary key
U unique constraint
V value ordered secondary
H hash ordered ALL covering secondary
O valued ordered ALL covering secondary
I ordering column of a composite secondary index
M Multi column statistics
D Derived column partition statistics
1 field1 column of a join or hash index
2 field2 column of a join or hash index