Oracle DBA SQL Quick Reference

Drop statements are used to remove objects from the database. You can drop the following objects:

Drop cluster

Drop context

Drop database link

Drop dimension

Drop directory

Drop function

Drop index

Drop indextype

Drop Java

Drop library

Drop materialized view

Drop materialized view log

Drop operator

Drop outline

Drop package

Drop procedure

Drop profile

Drop role

Drop rollback segment

Drop sequence

Drop synonym

Drop table

Drop tablespace

Drop trigger

Drop type

Drop type body

Drop user

Drop view