New versions: Dev (3.15) | Latest (3.14) | 3.13 | 3.12

DROP TYPE

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

This statement is used to drop an TYPE from the database catalog.

// Drop a type
create.dropType("type").execute();

CASCADE

It is possible to supply a CASCADE or RESTRICT clause, explicitly

// Specify the CASCADE / RESTRICT clauses explicitly
create.dropType("type").cascade().execute();
create.dropType("type").restrict().execute();
The jOOQ Logo