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();

Feedback

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

The jOOQ Logo