Deleting a Dbspace

Delete (drop) a dbspace from the database.

Prerequisites

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

The SAP Sybase IQ resource is authenticated and running.
In a multiplex configuration, the coordinator node is 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, expand IQ Servers > Space Management, and then select 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.