Delete a dbspace from the database.
Prerequisites
- Authenticate with Sybase IQ using an account that has DBA or Space Admin authority.
- You must be the only user connected to the database in order to delete a catalog dbspace. You can become the only connected user by dropping all secondary nodes.
- You cannot drop the six initial dbspaces (SYSTEM, TEMPORARY, IQ_SHARED_TEMP, IQ_SYSTEM_MAIN, IQ_SYSTEM_TEMP, and IQ_SYSTEM_MSG). You may drop dbspaces from the IQ main store or catalog store, which may contain multiple dbspaces, as long as at least one dbspace in read-write mode remains.
- The dbspace must contain no user data or user-created objects.
Task- In the Perspective Resources view, select the resource and select .
- In the left pane of the Administration Console, expand and select Dbspaces.
- In the right pane, select a dbspace to delete.
- Click the drop-down arrow that appears next to the dbspace name and select Delete.
- Click Yes to confirm the deletion.