topic Re: Add comment to multi columns with views in Get Started Discussions

Add comment to multi columns with views

anhbn2707 — Fri, 15 May 2026 08:03:49 GMT

With Table, I can add comment to multi columns by using:

ALTER TABLE your_table_name ALTER COLUMN col1 COMMENT 'comment1', col2 COMMENT 'comment2', col3 COMMENT 'comment3';

How can I do with views?

Re: Add comment to multi columns with views

-werners- — Fri, 15 May 2026 08:16:52 GMT

COMMENT ON COLUMN my_view.column_name IS 'My comment';
Props to Genie Code 🙂 (I was convinced it was not possible but I was wrong apparently)
This is col by col however.
With CREATE OR REPLACE VIEW you can add all comments in one go though.
You also have to be view owner.

Re: Add comment to multi columns with views

Lu_Wang_ENB_DBX — Fri, 15 May 2026 17:36:26 GMT

For views, there isn’t a single multi-column ALTER VIEW ... ALTER COLUMN col1 ..., col2 ... form. Update each column one at a time instead. Databricks supports column comments on views, and newer runtimes/SQL warehouses use COMMENT ON COLUMN; older fallback uses ALTER TABLE ... ALTER COLUMN ... COMMENT.

-- Recommended on SQL Warehouse / newer runtimes
COMMENT ON COLUMN catalog.schema.my_view.col1 IS 'comment1';
COMMENT ON COLUMN catalog.schema.my_view.col2 IS 'comment2';
COMMENT ON COLUMN catalog.schema.my_view.col3 IS 'comment3';

-- Older fallback syntax
ALTER TABLE catalog.schema.my_view ALTER COLUMN col1 COMMENT 'comment1';
ALTER TABLE catalog.schema.my_view ALTER COLUMN col2 COMMENT 'comment2';
ALTER TABLE catalog.schema.my_view ALTER COLUMN col3 COMMENT 'comment3';

If you’re creating/replacing the view, you can also define comments inline in the view column list.

CREATE OR REPLACE VIEW catalog.schema.my_view (
  col1 COMMENT 'comment1',
  col2 COMMENT 'comment2',
  col3 COMMENT 'comment3'
) AS
SELECT col1, col2, col3
FROM catalog.schema.source_table;