jOOQ's DDL support is currently still very limited. In the long run, jOOQ will support the most important statement types for frequent informal database migrations, though. Note that jOOQ will not aim to replace existing database migration frameworks. At Data Geekery, we usually recommend using Flyway for migrations. See also the tutorial about using jOOQ with Flyway for more information.

Table of contents

4.4.1.

The SET statement

4.4.2.

The ALTER statement

4.4.3.

The CREATE statement

4.4.4.

The DROP statement

4.4.5.

The TRUNCATE statement

4.4.6.

Generating DDL from objects