search

google-code-export / h2database

Automatically exported from code.google.com/p/h2database
0 stars 1 forks source link

Add DESCRIBE command to fill REMARKS column in INFORMATION_SCHEMA tables #248

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
It would be very useful to have DESCRIBE command to fill REMARKS column in 
INFORMATION_SCHEMA tables.

For example:

DESCRIBE TABLE T1 'Some T1 description';
DESCRIBE FIELD ID TABLE T1 'Some T1.ID description';
DESCRIBE CONSTRAINT UK_T1 TABLE T1 'Some UK_T1 for T1 description';

and so on

such command would be very useful to run from scripts.

in general this command just a comfortable wrapper around UPDATE for 
INFORMATION_SCHEMA tables.

Original issue reported on code.google.com by kua...@gmail.com on 30 Oct 2010 at 1:23

GoogleCodeExporter commented 9 years ago 
COMMENT can do what you want:
http://h2database.com/html/grammar.html#comment

Original comment by thomas.t...@gmail.com on 30 Oct 2010 at 1:47

GoogleCodeExporter commented 9 years ago 
ooops...
Thanks! It seems that I have not carefully searched in documentation

Original comment by kua...@gmail.com on 30 Oct 2010 at 2:06