No, the new field will be added last. If you really need the fields in a special order, which I think is a bad idea, you must go via a temp file. Create a new table with the correct structure and the fields in the correct order, and append from the temp table.

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