>Thanks George.
>
>I put that statements sequence in a prg and run it, but got a
"Class definition sqldmo.sqlserver is not found" error message.
>
>Please note that I don't have SQL Server installed in my PC, perhaps that's the problem, and that's why I need a VFP program do get the indices.
>
Fernando,
That's probably it. SQL-DMO is part of the administrative tools and is very powerful. I don't know of a method, that returns this information. SQLCOLUMNS() comes close, but doesn't appear to indicate whether or not a column is part of an index.
George
Ubi caritas et amor, deus ibi est