Re: Column COMMENTs in CREATE TABLE?

Em sábado, 2 de julho de 2016, David G. Johnston <david.g.johnston@gmail.com> escreveu:

On Sat, Jul 2, 2016 at 12:55 PM, Marko Tiikkaja <marko@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'

)​;

And what about the other CREATE statements? IMHO if we follow this path then we should add COMMENT to all CREATE statements and perhaps also to ALTER. Of course in a set of small patches to make the reviewers life easier.