alter table for Residual Data Removal

The alter table command supports the ability to remove residual data from deletions in SAP ASE.


The syntax to specify this in a table that already exists is:
alter table table_name
    set "erase residual data" {on | off}


When you set this option on a table, the operations for the table (drop table, delete row, alter table, drop index) that result in residual data automatically clean up deallocated space. The default is set to off.


Only the table owner or a user with alter any table permission can use the "erase residual data" option.