Application scenarios:
company Intranet data tables built after migrating to customers online, usually cannot be attached to export comments, need further pull
table field notes:
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
Table annotation:
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