Is there an SQL query for table schema ...

  • Thread starter Thread starter Bill
  • Start date Start date
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
 
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>
 
Back
Top