Comments can be added to tables, views and columns using the COMMENT ON syntax. The comments are stored in the metadata, and can be modified in a transactional manner.
COMMENT ON
Create a comment on a TABLE:
TABLE
COMMENT ON TABLE test_table IS 'very nice table';
Create a comment on a COLUMN:
COLUMN
COMMENT ON COLUMN test_table.test_table_column IS 'very nice column';
Comments can be added to tables, views and columns using the
COMMENT ON
syntax. The comments are stored in the metadata, and can be modified in a transactional manner.Examples
Create a comment on a
TABLE
:Create a comment on a
COLUMN
: