clickzetta-manage-comments

To add comments to a ClickZetta table or schema, you provide the target object type, its name, and the desired description. The system generates the correct ClickZetta-specific COMMENT statement with proper escaping rules applied.

ClickZetta metadata comments are supported across schemas, regular tables, external tables, dynamic tables, materialized views, VClusters, and workspaces. You can apply, modify, or delete descriptions for any of these supported object types.

To modify or delete a comment on a materialized view, you use the correct ClickZetta-specific COMMENT syntax. The system ensures safe updates by applying proper escaping rules and guiding you to avoid unsupported operations.

ClickZetta uses its own specific COMMENT syntax for dynamic tables rather than standard SQL. The system enforces supported object rules to ensure consistent and safe metadata description updates across all dynamic table operations.

The best way to ensure proper escaping when annotating VClusters is to use a consistent workflow that applies ClickZetta-specific COMMENT syntax. This prevents syntax errors and maintains safe metadata updates across workspace objects.

ClickZetta comment updates may fail if you attempt unsupported operations or use incorrect syntax. The system enforces supported object rules and documents differences between object types to ensure consistent, safe COMMENT operations.