COMMENT ON TABLE

commentOnTable("t").is("the comment")

ALTER TABLE t COMMENT = 'the comment'

COMMENT ON TABLE t IS 'the comment'

ALTER TABLE t SET OPTIONS (DESCRIPTION = 'the comment')

ALTER TABLE t MODIFY COMMENT 'the comment'

ALTER TABLE t SET COMMENT = 'the comment'

BEGIN TRY
  DECLARE @u varchar(max) = schema_name();
  EXEC sp_addextendedproperty 'MS_Description', 'the comment', 'schema', @u, 'table', 't', DEFAULT, DEFAULT
END TRY
BEGIN CATCH
  EXEC sp_updateextendedproperty 'MS_Description', 'the comment', 'schema', @u, 'table', 't', DEFAULT, DEFAULT
END CATCH

/* UNSUPPORTED */

Generated with jOOQ 3.21. Support in older jOOQ versions may differ. Translate your own SQL on our website