How can I get the IndexName from Dictionary?

Database
Fan

How can I get the IndexName from Dictionary?

Hi everybody. 

How can i get the IndexName from Dictionary Table or View?

I'm using this query. but the result is null. 

'IndicesX''s IndexName is also null.

Is there other table or view contains index name?

select IndexName from Indices

where DatabaseName = 'DBC'

and Tablename = 'AccessRights'

2 REPLIES
Senior Apprentice

Re: How can I get the IndexName from Dictionary?

If IndexName returns NULL there's no name.

In Teradata constraints don't need names (of course it's good practice to name it) and if you don't specify a name the systen doesn't create one (most DBMSes will automatically name based on tablename and timestamp or similar).

Fan

Re: How can I get the IndexName from Dictionary?

Thank you dnoeth. You are right ~