Hi,

Agnes already pointed you to the appropriate VFP commands. You could also have a look at the Stonefield DataBase Toolkit (http://www.stonefield.com) which handles database updates and other DB related things automatically. I haven't worked with it myself yet, but I often heard positive opinions in regards to the tool.

>As a software developer I have to change dbf file its structure at my clients place from time to time. Is there any way so that I can just write a small programme and run in clients computer and all the changes required it done automatically.
>The changes include creating & rmoving index tag, changing size of fields and adding new fields , relation, etc.
>Present I have to do all these thing manually. If throug coding it is possible please suggest and help.

HTH,
Armin