Adaptive Server 15.7 SP100 includes changes to the alter database command.
off
alter database allows you to shrink
databases, and adds the off parameter, which
specifies the device names from which you are releasing space. The syntax
is:
alter database database_name
. . .
off database_device {=size | [from page_number] [to page_number]}
[, database_device…]
[with timeout='time']