select 1 &&原表名为info.dbf,字段顺序为ypmc,chandi,id
copy to temp.dbf field id,ypmc,chandi
Run del .\dbf\info.dbf
RUN ren .\dbf\temp.dbf info.dbf
Use .\dbf\info.dbf in 1
哦,一时着急,数据表名称弄错了,
select 1
alter table customer add column c c(20)
copy to temp.dbf field a,c,b
Run del customer.dbf
RUN ren temp.dbf customer.dbf
Use .\dbf\customer.dbf in 1
to afant(afant) :
哦,不好意思,看错了!
添加字段是这样:
alter table customer add column c c(20)&&添加一个长度为20的字符弄字段
完整程序请参考:
select 1
alter table customer add column c c(20)
copy to temp.dbf field a,c,b
Run del .\dbf\info.dbf
RUN ren .\dbf\temp.dbf info.dbf
Use .\dbf\info.dbf in 1