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.

Table of contents

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 TABLE

3.6.4.8.1.

DROP TABLE IF EXISTS

3.6.4.9.

DROP TRIGGER

3.6.4.9.1.

DROP TRIGGER IF EXISTS

3.6.4.10.

DROP TYPE

3.6.4.10.1.

DROP TYPE IF EXISTS

3.6.4.11.

DROP VIEW

3.6.4.11.1.

DROP VIEW IF EXISTS