On 3/15/17, Simon Slavin <slav...@bigfraud.org> wrote:
> It’s common to see a four column table, with the columns being
> entityType
> theTable
> theName
> theComment

This approach has the advantage of being portable across *all* SQL
database engines, whereas the COMMENT ON command is (as far as I could
discern from Google) only available on Oracle and PostgreSQL.   This
approach also makes the comments easy to introspect from applications,
and update using general-purpose query tools.
D. Richard Hipp
sqlite-users mailing list

Reply via email to