Destroy Tables, Synonyms, Views, and Indexes
To destroy (delete) a table, synonym, view, or index, you must own them or have proper access permissions.
Note: Destroying a synonym does not destroy the underlying database table.
To destroy a table, synonym, view, or index and all its contents from a database
1. Place the cursor on the name of the table, synonym, view, or index you want to destroy, and select the Destroy operation.
A pop‑up form asks you for confirmation.
2. Place the cursor on yes to confirm that you want to destroy the selected object or no to leave the object as is.
3. Click the appropriate mouse button or select the Select operation.
You can also destroy a table, synonym, view, or index using a query language. For details, see your query language reference guide.
Keep in mind that you cannot later undo the destruction of a table, synonym, view, or index, or recover the contents of a destroyed table. To recover a table later, copy it to a file with the copydb command before deleting it from the database. Otherwise, you can recover the object only by restoring the entire database from a backup tape, if you have one. For instructions on using the copydb command, see the Database Administrator Guide.