On 11 Oct 2016, at 3:45am, sanhua.zh <sanhua...@foxmail.com> wrote: > I’m altering the all table's names, which takes a long time to finish. > But now, I use ‘PRAGMA writable_schema=ON’ to alter them, which is written > athttps://www.sqlite.org/lang_altertable.html > Although it is easy to corrupt the database, but I do it careful enough, and > testing adequate, it should be no problem
If you are altering table names in a production program then your table names are data. And if something is data it should be stored inside a table. It shouldn't be used as an table name. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
