How to Drop Data File in Sybase IQ



Share this article :

Before executing the activity, few items need to be consider,

• The data file must be empty
• You cannot remove the last data file in the DBspace. Instead, use DROP DBSPACE.

There are 2 ways of achieving this activity – using command-line or SAP Control Center (Wizard).

Using Command-Line

Use this command,

ALTER DBSPACE [DATABASE_NAME] DROP
FILE [DATA_FILE_NAME], 
FILE [DATA_FILE_NAME]

Using SAP Control Center

1. Navigate to the following directory and double click on the DB Files. On your right panel, you will see the available list of data files.

IQ Servers > Space Management > DB Files

2. Select on which data file to be delete and click Delete.

Confirm Deletion

Reference

Sybase Infocenter

Related posts

How to Drop Connection in Sybase IQ
User 'another user' has the row in 'ITSITI' locked
How to Add New Data File into Existing DBspace (Sybase IQ)
sp_iqwho: Displays information current user(s) and connection(s)
© 2018 ITsiti. All Rights Reserved
Powered by KEEM