alter table for Residual Data Removal

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

Syntax

The syntax to specify this in a table that already exists is:

alter table table_name
    set "erase residual data" {on | off}

Usage

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.

Permissions

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