COMMENT ON FUNCTION
Supported by ❌ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
commentOnFunction("f").parameters(in("p1", INTEGER), in("p2", INTEGER)).is("the comment")
Translates to the following dialect specific expressions:
Aurora MySQL, MariaDB, MySQL
ALTER FUNCTION f COMMENT 'the comment'
Aurora Postgres, Postgres, YugabyteDB
COMMENT ON FUNCTION f( p1 int, p2 int ) IS 'the comment'
ASE, Access, BigQuery, ClickHouse, CockroachDB, DB2, Databricks, DuckDB, Exasol, Firebird, H2, HSQLDB, Hana, Informix, MemSQL, Oracle, Redshift, SQLDataWarehouse, SQLServer, SQLite, Snowflake, Spanner, Sybase, Teradata, Trino, Vertica
/* UNSUPPORTED */
Generated with jOOQ 3.22. Support in older jOOQ versions may differ. Translate your own SQL on our website
Feedback
Do you have any feedback about this page? We'd love to hear it!