Adding Comments to Tables and Columns in Redshift database

You can add comments on below Redshift database objects:

• Database
• Table
• Columns
• Constraint
• View

Syntax:

COMMENT ON TABLE table_name IS 'enter your comment here';

COMMENT ON COLUMN table_name.column_name IS 'enter your comment here';

COMMENT ON CONSTRAINT constraint_name ON table_name IS 'enter your comment here';

COMMENT ON VIEW view_name IS 'enter your comment here';