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

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.: IF EXISTS
3.6.4.2.: DROP DOMAIN
3.6.4.2.1.: IF EXISTS
3.6.4.3.: DROP FUNCTION
3.6.4.3.1.: IF EXISTS
3.6.4.3.2.: DROP FUNCTION with signature (new)
3.6.4.4.: DROP INDEX
3.6.4.4.1.: IF EXISTS
3.6.4.5.: DROP PROCEDURE
3.6.4.5.1.: IF EXISTS
3.6.4.5.2.: DROP PROCEDURE with signature (new)
3.6.4.6.: DROP SCHEMA
3.6.4.6.1.: IF EXISTS
3.6.4.7.: DROP SEQUENCE
3.6.4.7.1.: IF EXISTS
3.6.4.8.: DROP SYNONYM
3.6.4.8.1.: IF EXISTS
3.6.4.9.: DROP TABLE
3.6.4.9.1.: CASCADE
3.6.4.9.2.: IF EXISTS
3.6.4.10.: DROP TRIGGER
3.6.4.10.1.: IF EXISTS
3.6.4.11.: DROP TYPE
3.6.4.11.1.: IF EXISTS
3.6.4.12.: DROP VIEW
3.6.4.12.1.: CASCADE (new)
3.6.4.12.2.: IF EXISTS

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