ddl - 如何向 Teradata 中的现有表 DDL 添加注释？

Question

我正在向表中添加一些新列，并希望向表 DDL 添加文档以供将来的开发人员使用。如何解决这个问题？

Answer 1

通用语法:

COMMENT ON {OBJECT} {OBJECTNAME} AS '{255 characters of text};

详细的语法示例:

COMMENT ON TABLE {DATABASE}.{TABLENAME} AS '{255 characters of text}';
COMMENT ON COLUMN {DATABASENAME}.{TABLENAME}.{COLUMNNAME} AS '{255 characters of text}';
COMMENT ON USER {USERNAME} AS '{255 characters of text}';
COMMENT ON DATABASE {DATABASENAME} AS '{255 characters of text}';