hi ,
thank you for reply and help,

is there away to add newfield to my table and put it as first field at my table vai alter
ALTER TABLE alldat ADD COLUMN num n(9) && as first field

thanks.

>>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
>