Before deleting a table, make sure that it is no longer needed.
To delete a table:
1. Choose Schema > Delete Table(s) from the menu bar. The Data Dictionary alphabetically lists all the tables defined for your database.
2. Select the table you want to delete or type ALL to delete all tables, then press GO. The Data Dictionary prompts you to verify that you want to delete the selected table.
3. Choose Yes. The Data Dictionary deletes the table from the database.
