Dropping a Table

Restriction: This topic applies to Windows environments only.

When you drop an XDB Server table, SQLWizard deletes all files associated with the table and removes its entries from the system catalog. Related indexes, keys, and relationships are also dropped. You cannot reverse a drop table action. Use the Drop command with care!

To drop a table:

  1. Click the Drop command from the Table menu.
    Note:


    *
    From the Catalog Browser dialog box, click the Table tab and choose table; then click the Drop button.

    SQLWizard displays the Open dialog box.

  2. Choose a table and click OK. SQLWizard displays the Drop Table dialog box.

    The table definition is shown so that you can verify it is the table you wish to drop. All fields in this window are disabled except for the five main buttons on the right.

  3. Click OK to drop the table.
  4. Click OK to confirm dropping the selected table.