The DROP statements can delete any already existing object.
Syntax of the DROP statement
DROP object name
Comments
| object | Determines what to drop. This may be TABLE, VIEW, INDEX or ROLE (see the chapter GRANT/REVOKE). |
| name | A name of an object to delete. |