DROP TABLE table_name;
|table_name||Name of the table to remove|
This statement is used to remove the same kinds of tables that are created with a CREATE TABLE statement. To drop views, use the DROP VIEW statement. To drop a table, you must own the schema in which the table resides or have (database administrator) DBA privileges.
The definition of the table is eliminated and all users lose their privileges on that table.
DROP TABLE STAFF