Causes Sybase IQ to leak, rather than reclaim, database disk space during a DROP command.
Requires DBA permissions to set this option. Can be set temporary for an individual connection or for the PUBLIC group. Takes effect immediately.
You must drop a corrupt index, join index, column or table and set the FORCE_DROP option to ON. This prevents the free list from being incorrectly updated from incorrect or suspect file space allocation information in the object being dropped. After dropping corrupt objects, you can reclaim the file space using the -iqfrec and -iqdroplks server switches.
When force dropping objects, you must ensure that only the DBA is connected to the database. The server must be restarted immediately after a force drop.
Do not attempt to force drop objects unless Sybase Technical Support has instructed you to do so.
FORCE_DROP procedures for system recovery and database repair are described in System Administration Guide: Volume 1.