On 21 October 2016 at 14:49, sanhua.zh <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
