注释的用法

CREATE TABLE my_graph (
  id varchar(50) NOT NULL ,
  name varchar(50) DEFAULT NULL ,
  imgCompress blob,
  conditionStr text
 );

COMMENT ON TABLE my_graph IS '测试';
COMMENT ON COLUMN my_graph.id IS '图谱ID';
COMMENT ON COLUMN my_graph.name IS '图谱名称';
COMMENT ON COLUMN my_graph.imgCompress IS '缩略图';
COMMENT ON COLUMN my_graph.conditionStr IS '图谱查询条件字符串';

 

1、注释的内容分别存储在syscomments和syscolcomments两个表中，这两个表确实tabid和colno；

2、dbschema无法打印注释

3、查看注释的做法是：

select a.comments,a.colname,c.colno,c.coltype,c.colmax
from systables t,syscolumns c,syscolcomments a
where  t.tabid=c.tabid
and a.tabname=t.tabname
and a.colname=c.colname