>hi,
>thank you for reply,
>i think alter table good idea for me,
>
>to add new field i can do ..
>ALTER TABLE Customer ADD COLUMN Fax c(20) NULL&&add from fvp help
>ALTER TABLE Customer DROP COLUMN Fax2 &&drop from fvp help
>
>but
>1.how i can change field name as under, from Area to state
>ALTER TABLE alldat ALTER COLUMN area n(5)
>2.how i can change field name and data type of filed

I don't have VFP 9 installed right now.

According to the help of version 6, it seems that you can not change the column name with ALTER TABLE. Perhaps there is a way in VFP 9 - I don't know.

However, you can copy the information to a new column (field). Do the following (assuming you want to change from character to currency):

alter table MyTable add column NewColumn Y
update MyTable set NewColumn = val(OldColumn)
alter table MyTable drop column OldColumn