Index Name(s)

I am using Access 2003

Is there a way to use SQL to get the Index Names on a table?

I can get the data if I go to Tools-Analyze-Documenter, select the
"Tables" tab, select the table I want and then click OK. A report is
displayed in a window. I am using the data in the "Table Indexes"
section

Can I use SQL to get this information, if I know the table name?

Thanks

You can get at the indexes and their properties through DAO.

The core idea (aircode) is:
Dim db As DAO.Database
Dim tdf As DAO.Tabledef
Dim ind As DAO.Index

Set db = CurrentDb
For Each tdf in db.TableDefs
For each ind in tdf.Indexes
Debug.Print ind.Name
next
Next

You probably want to skip the tables where the name starts with "~", or
(tdf.Attributes And dbSystemObject) 0

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

wrote in message
...
I am using Access 2003

Is there a way to use SQL to get the Index Names on a table?

I can get the data if I go to Tools-Analyze-Documenter, select the
"Tables" tab, select the table I want and then click OK. A report is
displayed in a window. I am using the data in the "Table Indexes"
section

Can I use SQL to get this information, if I know the table name?

Thanks