Previous Topic Next topic Print topic


To drop a table

To drop a table in the current location:

  1. Click SQL for DB2 on the Tools menu; then click SQL Wizard.
  2. If the Catalog Browser window is not open, click
    *
    to open it.
  3. On the Catalog Browser window, ensure the Table tab is selected.
  4. Click the table you want to drop.
  5. Click Drop.
  6. 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.
Previous Topic Next topic Print topic