All the index information in Teradata stored in dbc.indices dictionary and the index type for Primary index is ‘Q’ SEL * FROM dbc.indices WHERE indextype = 'Q' AND databasename='<database name>';
Teradata considers PPI as constraints and also store the partition expression in dbc.indexconstraints SEL * FROM dbc.indexconstraints WHERE constraintType='Q' AND databasename='<database name>'; |