Luca Ferrari wrote:
> 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.
If those annotations are to be queried, put them into a table.
Otherwise, if you want it to look good even after an ALTER TABLE, put
the comment before the comma:
CREATE TABLE ... (
...
Col /* hi! */,
...
);
To ensure that there is a comma after the last column, always use
a table constraint (e.g., PRIMARY KEY, or a dummy CHECK(1)).
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
