Available in versions: Dev (3.20) | Latest (3.19) | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10

This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.

The DROP statement

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

The DROP statement is used to drop objects from the database catalog.

3.6.4.1.: DROP DATABASE
3.6.4.1.1.: DROP DATABASE IF EXISTS
3.6.4.2.: DROP DOMAIN
3.6.4.2.1.: DROP DOMAIN IF EXISTS
3.6.4.3.: DROP FUNCTION
3.6.4.3.1.: DROP FUNCTION IF EXISTS
3.6.4.4.: DROP INDEX
3.6.4.4.1.: DROP INDEX IF EXISTS
3.6.4.5.: DROP PROCEDURE
3.6.4.5.1.: DROP PROCEDURE IF EXISTS
3.6.4.6.: DROP SCHEMA
3.6.4.6.1.: DROP SCHEMA IF EXISTS
3.6.4.7.: DROP SEQUENCE
3.6.4.7.1.: DROP SEQUENCE IF EXISTS
3.6.4.8.: DROP SYNONYM (new)
3.6.4.8.1.: DROP SYNONYM IF EXISTS (new)
3.6.4.9.: DROP TABLE
3.6.4.9.1.: DROP TABLE IF EXISTS
3.6.4.10.: DROP TRIGGER
3.6.4.10.1.: DROP TRIGGER IF EXISTS
3.6.4.11.: DROP TYPE
3.6.4.11.1.: DROP TYPE IF EXISTS
3.6.4.12.: DROP VIEW
3.6.4.12.1.: DROP VIEW IF EXISTS
3.6.4.12.2.: DROP MATERIALIZED VIEW

previous : next

References to this page

SQL Statements (DDL)

Feedback

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

Tell us a little bit about yourself and join our newsletter (examples)

The DROP statement

Table of contents

References to this page

Feedback

Community

Support

Legal

Documentation