If you want the option of a partial database restore then you have to take a partial database backup. For example, if you have to perform data maintenance on a table and you want to make sure that you can revert back to the data set prior to the change, then you should take a backup of the table’s data set. Use CREATE TABLE AS SELECT to store a copy of the data in a different table, or use the COPY statement to export the data from the table into a file. To restore the table, use MODIFY...TO TRUNCATED or the MODIFY...TO COMBINE command to delete all the data from the table:

Then, use INSERT AS SELECT FROM to reinsert the data, or the COPY statement to read the data from the file back into the table.