达梦数据库表SQL语句

--给表加注释
comment ON TABLE T_D_BXZZ_KM_MAP IS '保险总账科目映射'
--查询表注释
select comments from user_tab_comments where table_name = 'T_D_BXZZ_KM_MAP'
--给表字段加注释
comment ON COLUMN T_D_BXZZ_KM_MAP.C_KM_CODE IS '科目代码'
--查看表字段注释
SELECT * FROM user_col_comments co
WHERE co.TABLE_NAME='T_D_BXZZ_KM_MAP'