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!

To drop a location:

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

   
   
   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.