Remove a table

If you are the administrator, the owner of the table, or have Drop privilege on the table or the table class, you can drop a table. You might need to drop a table to implement a new design or to free space in your database.

Dropping a table causes its structural definition, data, and constraints to be permanently deleted from the database. The system makes the space that was used to store the table available to other tables.

   MYDB.SCHEMA(USER)=> DROP TABLE weather;