删除一个字段的方法

http://topic.csdn.net/u/20100603/11/d497e0aa-905a-451d-b45c-c5d44bf80ab2.html

 

引用楼主 jileniao 的回复:
在sqlite中，我用alter table D_BrandService add column a int default 0;语句给表D_BrandService加了个字段a，执行成功，结果用alter table D_BrandService drop column a;（或alter table D_BrandService drop a;）语句一执行，提示我drop附近有语法错误，请熟悉……


sqlite> create table D_BrandService(id int);
sqlite> alter table D_BrandService add column a int default 0;
sqlite> create table tmp as select id from D_BrandService;
sqlite> drop table D_BrandService;
sqlite> alter table tmp rename to D_BrandService;