On 15 Mar 2017, at 2:45pm, Bart Smissaert <bart.smissa...@gmail.com> wrote:

> Maybe it is simpler (no parsing needed) to have an extra table with a
> unique column holding tablename_fieldname
> and a second column holding the comment for that field.

It’s common to see a four column table, with the columns being

entityType
theTable
theName
theComment

(I picked column names that suit me.  I don’t know of a standard.  Use of 'the' 
is to make sure you aren’t using reserved words as entity names.)

This allows you to comment things like indexes and triggers as well as columns.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to