从SQLite表中删除列

前端之家收集整理的这篇文章主要介绍了从SQLite表中删除列前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
我有一个问题:我需要从我的sqlite数据库删除一个列。我写了这个查询
alter table table_name drop column column_name

但它不工作。请帮帮我。

来自: http://www.sqlite.org/faq.html

(11) How do I add or delete columns from an existing table in sqlite.

sqlite has limited ALTER TABLE support that you can use to add a
column to the end of a table or to change the name of a table. If you
want to make more complex changes in the structure of a table,you
will have to recreate the table. You can save existing data to a
temporary table,drop the old table,create the new table,then copy
the data back in from the temporary table.

For example,suppose you have a table named “t1” with columns names
“a”,“b”,and “c” and that you want to delete column “c” from this
table. The following steps illustrate how this could be done:

06000

原文链接:https://www.f2er.com/sqlite/198340.html

猜你在找的Sqlite相关文章