You can alter an existing base table so that it is enabled or disabled for RLV
storage.
Prerequisites
- SAP Sybase IQ server has a simplex database.
- The RLV dbspace exists with at least one dbfile.
- Requires ALTER ANY OBJECT or ALTER ANY TABLE system privilege.
TaskTo enable or disable RLV storage settings on an existing table, execute:
ALTER TABLE [ owner.]table-name
{ ENABLE | DISABLE } RLV STORE
- table-name – the name of table for which the RLV storage is to be enabled or
disabled.