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.4.4.1.

DROP INDEX

3.4.4.1.1.

DROP INDEX IF EXISTS

3.4.4.2.

DROP SCHEMA

3.4.4.2.1.

DROP SCHEMA IF EXISTS

3.4.4.3.

DROP SEQUENCE

3.4.4.3.1.

DROP SEQUENCE IF EXISTS

3.4.4.4.

DROP TABLE

3.4.4.4.1.

DROP TABLE IF EXISTS

3.4.4.5.

DROP TYPE (new)

3.4.4.5.1.

DROP TYPE IF EXISTS (new)

3.4.4.6.

DROP VIEW

3.4.4.6.1.

DROP VIEW IF EXISTS