WITH CHECK OPTION

// Create a new view
create.createView("early_authors", "author_id", "first_name", "last_name")
      .as(select(AUTHOR.ID, AUTHOR.FIRST_NAME, AUTHOR.LAST_NAME)
          .from(AUTHOR)

          // Any inserted or updated authors must continue to satisfy this condition
          .where(AUTHOR.ID.lt(200))

          // The flag is set on the Select object, not the view
          .withCheckOption())
      .execute();

The flag is set on the SELECT object, not the CREATE VIEW statement, as it is also made available to inline views.

createView("a", "id").as(select(AUTHOR.ID).from(AUTHOR).withCheckOption())

CREATE VIEW a(id)
AS
SELECT AUTHOR.ID
FROM AUTHOR
WITH CHECK OPTION

/* UNSUPPORTED */

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