The jOOQ User Manual SQL execution Database meta data Interpreted meta data

previous : next

Interpreted meta data

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

jOOQ's parser is used by a DDL interpreter to create an alternative implementation of org.jooq.Meta based on your DDL scripts:

// Using strings:
create.meta(
         "create table a (i int);",
         "create table b (j int);",
         "create table c (k int);"
       )
      .getTables()
      .forEach(System.out::println);

// Using the jOOQ API:
create.meta(
         createTable("a").columns("i", INTEGER),
         createTable("b").columns("j", INTEGER),
         createTable("c").columns("k", INTEGER)
       )
      .getTables()
      .forEach(System.out::println);

The above prints all of the tables from the DDL scripts

a
b
c

All the meta data is available, including column names, types, constraints, etc.

DDL can be interpreted from strings or from org.jooq.Source, which represents any string providing source, including files, input streams, etc.

Exporting DDL

Any org.jooq.Meta implementation can be exported back to DDL statements (translated to any dialect!) using Meta.ddl()

The jOOQ User Manual SQL execution Database meta data Interpreted meta data

previous : next