Mnay thanks for replies.... gives me food for thought.
Regards,
Gerard



>>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
>>
>>Tia
>>Gerard
>
>
>You could connect to SS via SQL pass through - then query the table you want the structure of - finally use the copy structure command on the resulting cursor