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. |
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 .
- In the left pane, select .
- 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 .
Tip: Use Shift-click or
Control-click to select multiple dbspaces.
- Click Yes to confirm deletion.