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: 04/03/2024