see SQLCOLUMNS() in the help.
it returns a cursor that you can do what you want with.
>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
Insanity: Doing the same thing over and over and expecting different results.