Actian X 11.1 | MODIFY...TO TABLE_RECOVERY_ALLOWED

SQL Reference Guide > SQL Reference Guide > SQL Statements > MODIFY > MODIFY...TO TABLE_RECOVERY_ALLOWED | TABLE_RECOVERY_DISALLOWED

Was this helpful?

MODIFY...TO TABLE_RECOVERY_ALLOWED | TABLE_RECOVERY_DISALLOWED

To prevent the possibility of logically or physically inconsistent tables due to table-level recovery, table-level recovery can be disallowed for any table with the MODIFY...TO TABLE_RECOVERY_DISALLOWED command.

Syntax to mark a table as allowed or disallowed for table-level recovery:

[EXEC SQL] MODIFY tablename|indexname TO TABLE_RECOVERY_ALLOWED|TABLE_RECOVERY_DISALLOWED

Last modified date: 11/09/2022