Shrinking Databases

In Adaptive Server versions 15.7 SP100 and later, use the alter database command to shrink databases, freeing unused space for reuse or deletion.

If Adaptive Server encounters data on the portion of the database you are shrinking, it moves the data to a new location before removing the space from the database. Once the portions to be removed are empty, the physical storage is replaced by references to a null device, which frees the space and makes it available for reuse or deletion.

You can shrink databases that are online and in use.