Luca Ferrari wrote: > CREATE TABLE pratica_protocollo( > ... > note varchar( 2048 ) -- note per l'integrazione > ); > > ALTER TABLE pratica_protocollo ADD COLUMN cage_attribuzione_anno > integer; > ALTER TABLE pratica_protocollo ADD COLUMN cage_attribuzione_numero > integer; > > and the .schema on the table provides now: > > CREATE TABLE pratica_protocollo( > ... > > note varchar( 2048 ), cage_attribuzione_anno integer, > cage_attribuzione_numero integer, -- note per l'integrazione > ) > > As you can see, the columns have been added before the SQL comment on > the last column of the table.
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. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
