>>>Hi.
>>>I am able to use a command 'Copy Stru Exte' to get the structure of a DBF table
>>>Is there any way in VFP that I can do something similar to get the structure of a Sql Server Table
>>
>>sqlcolumns(handle, "yourtable")
>>
>>but that gives you minimal information.
>
>Actually, you can pass a 3rd param of "NATIVE" to SQLColumns() to get whatever info the server will provide.
I wish I read the help that far when I should have. It would have saved me some digging through stored procedures.