Available in versions: Dev (3.20)

This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.

Hidden columns

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

There are various reasons why a column could be hidden, including:

  • The column is formally marked as HIDDEN or INVISIBLE, if the database product supports this.
  • A forced type marks the column as hidden.

jOOQ's code generator can detect some of these, and mark columns as hidden for you, meaning that the column will not be taken into consideration in default projections. For details about the runtime behaviour of such hidden columns, please see the relevant section about hidden columns.


The hidden flag is a property of the generated org.jooq.DataType. As such, the property can only be enforced on expressions which make this flag available to jOOQ. For example, if you're using plain SQL templates without passing along a DataType with the hidden flag enabled to table meta data, then it cannot be enforced. See also features requiring code generation for more details.


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

The jOOQ Logo