查询表comment

查询表注释：

select a.tabname,a.comments from syscomments a,systables b where a.tabname = b.tabname and b.tabid >= 99;

输出示例：

tabname   t
comments  表t comment

查询字段注释：

select a.* from SYSCOLCOMMENTS a,systables b where a.tabname = b.tabname and b.tabid >= 99;

输出示例：

tabname   t
colname   col1
comments  t.col1