![FLOAT_AS_DOUBLE option [TSQL]](arrow-left.gif){kind=icon}
Causes IQ to leak database disk space during a DROP command rather than reclaim it.
ON, OFF
DBA permissions are required to set this option. Can be set temporary, for an individual connection, or for the PUBLIC group. Takes effect immediately.
OFF
If it is necessary to drop a corrupt index, join index, column or table, the FORCE_DROP option should be set to 'ON'. This will prevent the free list from being incorrectly updated from incorrect or suspect file space allocation information in the object being dropped. After dropping corrupt objects the file space may be reclaimed 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.
You should not attempt to force drop objects, unless Sybase Technical Support has instructed you to do so.
For important information on using this option, refer to Chapter 2, “System Recovery and Database Repair” in the Sybase IQ Troubleshooting and Error Messages Guide.
