Retrieve list of indexes in an Access database
- by waanders
I know there's a way to get a list of all tables in an Access database by using the quering the MsysObjects: "SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<'~') AND (Left$([Name],4)<'Msys') AND (MSysObjects.Type)=1 ORDER BY MSysObjects.Name"
Does anybody know a similar (or other) way to retrieve a list of all indexes in an MS-Access database?