Is there an SQL query for table schema ...

B

Bill

Hello ,

Is there an SQL query that will return a list of all indexes on a
particular table?

In addition will it list the fields involved if it is a compound index?

Thanks,

Bill
 
J

Jeff Boyce

Bill

You've asked a "how" question (how do I use SQL to ...). If what you are
after is a list of indexes for a table, the answer to this "what" question
(I need a list of indexes for a table) can be done by using the
Tools/Analyze/Documenter feature.

Good luck

Jeff Boyce
<Access MVP>
 
Top