应用场景:
公司内网建好数据表之后迁移到客户线上时,通常无法附带导出注释,需要另行拉取
表字段注释:
SELECT
*
FROM
(
SELECT
'comment on column ' || trim(t.TABSCHEMA) || '.' || t.TABNAME || '.' || t.COLNAME || ' is ' || '''' || t.REMARKS || '''' || ' GO' AS COMMENT
FROM
syscat. COLUMNS t
)
WHERE
COMMENT IS NOT NULL
表注释:
SELECT
*
FROM
(
SELECT
'comment on table ' || trim(t.tabschema) || '.' || t.tabname || ' is ' || '''' || t.REMARKS || '''' || ' GO' AS COMMENT
FROM
syscat. TABLES t
)
WHERE
COMMENT IS NOT NULL