Retrieve list of indexes in an Access database
Posted
by waanders
on Stack Overflow
See other posts from Stack Overflow
or by waanders
Published on 2010-03-29T09:43:54Z
Indexed on
2010/03/29
10:13 UTC
Read the original article
Hit count: 359
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?
© Stack Overflow or respective owner
