Database meta data

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

Not only the code generator, but also the runtime library offers a way to access database meta data. This API is made available as org.jooq.Meta, and it has several implementations, out of the box:

• A JDBC backed implementation querying java.sql.DatabaseMetaData
• A DDL interpreter backed implementation that parses and interprets a set of DDL scripts
• An XML backed implementation (implementing https://www.jooq.org/xsd/jooq-meta-3.20.0.xsd)
• A generated code backed implementation.

The following sections document each one of the above.

Table of contents

4.17.1.

JDBC meta data

4.17.2.

Interpreted meta data

4.17.3.

XML meta data

4.17.4.

Generated meta data