ALTER TABLE table-name ADD COLUMN column-name column-type 例如在student表中添加一列名为name,类型为varchar: alter table student add column name varchar;
alter table student drop column name // 该行在sqlite中不能用,sqlite不支持drop
详见:SQlite在已创建的表中删除一列原文链接:https://www.f2er.com/sqlite/200223.html