On 21 October 2016 at 14:49, sanhua.zh <sanhua...@foxmail.com> wrote:
> Don't do this. > I don’t think so. It is written on the sqlite.com. So it should be a > tricky way but not a wrong way. > The docs say, regarding the procedure you followed: > The following simpler procedure is appropriate for removing CHECK > or FOREIGN KEY or NOT NULL constraints, renaming columns, or > adding or removing or changing default values on a column. Note that "renaming tables" is not included here. You should probably use ALTER TABLE for that :) -Rowan _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users