On Sat, Jul 2, 2016 at 12:55 PM, Marko Tiikkaja <ma...@joh.to> wrote:
> > What I would prefer is something like this: > > CREATE TABLE foo( > f1 int NOT NULL COMMENT > 'the first field', > f2 int NOT NULL COMMENT > 'the second field', > ... > ); > > which would ensure the comments are both next to the field definition > they're documenting and that they make it all the way to the database. I > looked into the biggest products, and MySQL supports this syntax. I > couldn't find any similar syntax in any other product. > > +1 for the idea - though restricting it to columns would not be ideal. CREATE TABLE name COMMENT IS 'Table Comment Here' ( col1 serial COMMENT IS 'Place comment here' ); David J.