DROP문

<drop statement>

<drop class statement>
| <drop trigger statement>
| <drop deferred trigger statement>
| <drop serial statement>
| <drop index statement>
| <drop variable statement>

<drop class statement>

DROP [ <class type> ] <class specification comma list>

<drop trigger statement>

DROP TRIGGER <trigger name comma list>

<drop deferred trigger statement>

DROP DEFERRED TRIGGER <trigger spec>

<drop serial statement>

DROP SERIAL <serial name>

<drop index statement>

DROP [REVERSE] [UNIQUE] INDEX [index name] ON <class name>
| ( <attribute name> )

<drop variable statement>

DROP VARIABLE <variable comma list>

<trigger spec>

<trigger name comma list>
| ALL TRIGGERS

<class specification>

<class hierarchy>
| ( <class hierarchy comma list> )

<class hierarchy>

[ONLY] <class name>
|ALL <class name> [EXCEPT <class specification> ]

예제

DROP person, employee;

DROP INDEX ON employee (name);
DROP INDEX ON employee (ssn, name);

DROP TRIGGER check_salary;

DROP DEFERRED TRIGGER check_salary, check_age;
DROP DEFERRED TRIGGER ALL TRIGGERS;