>I have a routine which I need to adapt to support a SQL Server table. In it, for a VFP table, I am using AFIELD() to extract the fields information. What can I do, from VFP, to obtain the same from a specific SQL Server table?

Without knowing exactly your needs, the others may have given you the best answer. However, SQLDMO can supply information that may not be given with the other two solutions. Further, it can be used to automate certain tasks.