The DROP statement

Available in ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition

jOOQ currently supports the following DROP statements (SQL examples in PostgreSQL syntax):

Indexes

// Drop an index
create.dropIndex("I_AUTHOR_LAST_NAME").execute();

// Drop an index only if it exists (not all databases support this)
create.dropIndexIfExists("I_AUTHOR_LAST_NAME").execute();

Schemas

// Drop a schema
create.dropSchema("schema").execute();

// Drop a schema only if it exists (not all databases support this)
create.dropSchemaIfExists("schema").execute();

Sequences

// Drop a sequence
create.dropSequence(S_AUTHOR_ID).execute();

// Drop a sequence only if it exists (not all databases support this)
create.dropSequenceIfExists(S_AUTHOR_ID).execute();

Tables

// Drop a table
create.dropTable(AUTHOR).execute();

// Drop a table only if it exists (not all databases support this)
create.dropTableIfExists(AUTHOR).execute();

Views

// Drop a view
create.dropView(V_AUTHOR).execute();

[// Drop a view only if it exists (not all databases support this)
create.dropViewIfExists(V_AUTHOR).execute();

The jOOQ User Manual. Multiple Pages : SQL building : SQL Statements (DDL) : The DROP statement

previous : next