Thanks. The only way I knew is to use VB or SQL Script, but I
find that is not flexible enough. Why can't VFP able to perform
this task and need VB to come in?

Rick, what do you mean by using Visual Data Tool? Could you
advise on how to go about editing the SQL table structure?
Thanks.

>>Anyone knows is there a way to edit/modify Table Structure
>>in VFP environment once the database is upsized to
>>MS SQL 6.5? Thanks!
>
>Not in VFP. If you have Visual Studio you can use Visual Data Tools.