G0574's Archiver

弯月圆刀 发表于 2008-11-14 14:12

sqlite的alter table

sqlite部分地支持alter table。

SQLite supports a limited subset of ALTER TABLE. The ALTER TABLE command in SQLite allows the user to rename a table or to add a new column to an existing table. It is not possible to rename a colum, remove a column, or add or remove constraints from a table.
可以:
1、重命名一个table
2、增加一个字段

不可以:
1、字段重命名
2、删除字段

页: [1]

Powered by Discuz! Archiver 6.1.0  © 2001-2007 Comsenz Inc.