You can use either the QMF ERASE command or the SQL DROP statement to erase tables, views, synonyms, and aliases from the database.
For example, to use the QMF ERASE command to delete the CALENDAR table, enter:
ERASE TABLE CALENDAR
To use the SQL DROP statement to erase the same table, run this query:
DROP TABLE CALENDAR
When you use either the DROP statement or the ERASE command to delete a table from the database, any views or synonyms you created from them are also dropped.
To erase a table, you must be the owner of the table or have DBADM authority.
To erase a view or an alias, you must be the owner or have SYSADM or SYSCTRL authority.
To erase a synonym, you must be the owner of the synonym.