On Mon, May 30, 2016 at 12:24 PM, Clemens Ladisch <clem...@ladisch.de> wrote: > This is normal. The ALTER TABLE adds the new column(s) immediately > behind the actual column definition. Inserting a comma before the > comment and the rest of the new column definition in the next line would > be too complex; and in any case the DB cannot know whether the comment > belongs to the column or the table.
Thanks, I was suspecting it. Is there a "correct" way to annotate SQL schema? Other databases provides special commands (e.g., PostgreSQL ADD COMMENT), but I don't see nothing in SQLIte3 syntax except the SQL '--' one. Thanks, Luca _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users