Deleting (Dropping) a Dbspace

Delete (drop) a dbspace from the database.

Prerequisites

Database Version	Dbspace Privileges
SAP Sybase IQ 15.3 and 15.4	Requires one of: DBA authority. SPACE ADMIN authority.
SAP Sybase IQ 16.0	Requires MANAGE ANY DBSPACE system privilege.

The SAP Sybase IQ resource is authenticated and running.
For catalog dbspaces, you are the only user connected to the database.
The dbspace being dropped contains no user data or user-created objects.
For a dbspace in an RLV store, there are no existing RLV-enabled tables, and the RLV dbspace is read-only.
Note: Dropping the dbspace from the RLV store prevents the creation of new RLV-enabled tables.

Task

You may drop dbspaces from the IQ main store or system store (catalog store), as long as at least one dbspace in read-write mode remains. You cannot drop the six initial dbspaces (SYSTEM, TEMPORARY, IQ_SHARED_TEMP, IQ_SYSTEM_MAIN, IQ_SYSTEM_TEMP, and IQ_SYSTEM_MSG).

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers > Space Management > Dbspaces.
Select one or more dbspaces from the right pane and either:
- Click the arrow to the right of the name and select Delete, or
- From the Administration Console menu bar, select Resource > Delete.
Tip: Use Shift-click or Control-click to select multiple dbspaces.
Click Yes to confirm deletion.