Dropping a Location

When you drop a location, its directory and all of the tables, indexes, and associated files are deleted. You cannot reverse this process. Use the Drop command with care!

Note:

To drop a location, you must be connected to a different location. To change your current location, click Set Location on the Location menu.

You cannot drop a location to which you are attached. If you receive the error "X131:Attempt to drop location in use" when dropping a location, exit SQLWizard and restart the program, logging onto a different location. Then drop the other location.

To drop a location:

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


    Catalog Browser button
    From the Catalog Browser dialog box, choose a location from the Location folder and click the Drop button.

    SQLWizard displays the Drop Location dialog box.

  2. Specify the name of the location you want to drop in the Location Name field. Click the down-arrow button to view the existing names on the drop-down list. SQLWizard reads the system catalog entries for the location and displays the appropriate information.

    Optionally, you can type a name in the Location Name field instead of choosing a name from the drop-down list. If you type a location name, be sure to click a different field on the window to let SQLWizard know that you are done typing.

  3. Review the information to verify that this is the location you want to drop and that you are currently connected to a different location. Your current location is displayed in the status bar at the bottom right of the SQLWizard window.
  4. Click OK to drop the location.
  5. Click OK to confirm dropping the location.