DROP

A DDL statement that permanently removes an object and all its contents from the repository.

See the DROP statements topic in the SQL Reference Guide for more information.