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
ducklake_tag
ducklake_column_tag
ducklake_view_column_tag
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';
Create a comment on a view column:
CREATE VIEW test_view (view_column) AS SELECT test_table_column FROM test_table; COMMENT ON COLUMN test_view.view_column IS 'very nice view column';
View column comments use the view's output column names and require DuckLake format version 1.1.
Comments can be added to tables, views, and columns using the
COMMENT ONsyntax. The comments are stored in the metadata, and can be modified in a transactional manner:ducklake_tagtable.ducklake_column_tagtable.ducklake_view_column_tagtable.Examples
Create a comment on a
TABLE:Create a comment on a
COLUMN:Create a comment on a view column:
View column comments use the view's output column names and require DuckLake format version 1.1.