Delete All Objects in the Database
To delete all objects in the selected database
1 Click File>Drop to drop join or hash indexes defined on tables, as well as authorizations and UDTs.
2 Drop any journal table by issuing a MODIFY DATABASE <name> DROP DEFAULT JOURNAL TABLE statement from the Query window.
Note: All objects listed in Step 1 and journal tables must be dropped before proceeding to Step 3.
3 Select the database in the tree area.
4 Click File>Drop all Objects in DB.