Re: Is there an SQL query for table schema ...

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>

"Bill" <BDumbleton@xxxxxxxxx> wrote in message
news:%23soo4t3cFHA.3120@xxxxxxxxxxxxxxxxxxxxxxx
> 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
>
>

.

Relevant Pages

  • Re: access 2000 date query
    ... But at other times I build SQL strings with code that change to much to use ... Bill ... >> Access 2000 sql query. ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • Is there an SQL query for table schema ...
    ... Is there an SQL query that will return a list of all indexes on a ... In addition will it list the fields involved if it is a compound index? ... Bill ... Prev by Date: ...
    (microsoft.public.access.queries)
  • access 2000 date query
    ... Access 2000 sql query. ... The database is set to use ANSI 92, ... Bill ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • Using assemlby without depending on it
    ... manually called GetMethd, GetProperty(), and Invoke for every value I ... Bill ... Prev by Date: ...
    (microsoft.public.dotnet.framework)
  • Re: Entourage printing issues
    ... but I was remiss in not saying THANKS to Bill for the help.!!! ... Prev by Date: ...
    (microsoft.public.mac.office.entourage)