Thanks Larry, I will give it a try.
>>Hello,
>>
>>VFP has the command DISPLAY STRUCTURE. How do you display the structure of a SQL table? I would like to save the structure layout in a file if possible.
>>
>>Thanks,
>>
>>TFISHER
>
>Terry,
>Trey and Dave gave you a couple of options. You could also use the following SQL statement:
>select * from mySQLtable where 1 = 0
>It will return no rows but an empty VFP cursor will be created and you can get the structure of that.
>
>This is a little different in that the VFP conversions (e.g. long varchar to Memo) will already have been done for you. You will get a representation of the VFP data not a true representation of the actual field types from SQL Server.
>
>HTH.
Thanks,
TFISHER