Available in versions: Dev (3.20) | Latest (3.19)

COMMENT ON MATERIALIZED VIEW

Applies to ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

This statement is used to comment on a materialized view.

Dialect support

This example using jOOQ:

commentOnMaterializedView("view").is("the comment")

Translates to the following dialect specific expressions:

BigQuery

ALTER MATERIALIZED VIEW view SET OPTIONS (DESCRIPTION = 'the comment')

Oracle, Postgres, Sybase, YugabyteDB

COMMENT ON MATERIALIZED VIEW view IS 'the comment'

Snowflake

ALTER TABLE view SET COMMENT = 'the comment'

ASE, Access, Aurora MySQL, Aurora Postgres, ClickHouse, CockroachDB, DB2, Derby, DuckDB, Exasol, Firebird, H2, HSQLDB, Hana, Informix, MariaDB, MemSQL, MySQL, Redshift, SQLDataWarehouse, SQLServer, SQLite, Teradata, Trino, Vertica

/* UNSUPPORTED */
Generated with jOOQ 3.20. Translate your own SQL on our website

Feedback

Do you have any feedback about this page? We'd love to hear it!

The jOOQ Logo