To drop a table in the current location:
- Click
SQL for DB2
on the
Tools menu;
then click
SQL Wizard.
- If the Catalog Browser window is not open, click
to open it.
- On the Catalog Browser window, ensure the
Table tab is selected.
- Click the table you want to drop.
- Click
Drop.
- Click
OK to confirm your request.
SQL Wizard deletes the files associated with the table and removes the entries about the table from the system catalog.
Note: You cannot recover a table once it has been dropped.