>>>>
>>>>If you're using SQL Server, this information is already available to use in various meta-tables (views)
>>>>
>>>>Say, you can check Information_Schema.Columns to get information about columns and you can look into extended properties to get descriptions of the fields (if you need to get this information too).
>>>
>>>I will look into this approach. Thank you.
>>
>>Yes, it sounds like it will work nicely. You get the schema for particular table using
>>

>>select * from Information_Schema.Columns where Table_Name = 'MyTable' and schema_name = 'dbo'

>>and then you construct your SelectCMD and other commands using that info.
>>
>
>It is strange that when I execute the above command (changing schema_name to table_schema) in SQL Server SMMS, I get a nice table where each row is information on a column in a table. When I execute this command from VFP, I get a table with no records where each column name is the name of the column in the table. Do you know why it is so?

What do you mean by when you execute it from VFP? Try also only to get Column_Name and type for now.