The RESET command adjusts the last modification date/time stamp for tables and views.
When copying table and view information with the UNLOAD command, the output automatically generates RESET commands after the table/view definition, to reset the date/time stamp and retain the original value.
tblview
Specifies a table or view.
value
Specifies the date/time stamp for tables or views.
About the RESET Command
The RESET command was introduced for tables and views to retain their last modification date/time stamp when the structure is unloaded from a database. The RESET command follows the CREATE TABLE command in the output. To toggle whether or not the RESET command is included in the unloaded structure use the RESET setting.
Examples
The below resets the last modification date and time stamp for the LicenseInformation table.
RESET LicenseInformation LAST_MOD TO '12/15/2025 12:00'
The below resets the last modification date and time stamp for the SalesDataByCompany view.
RESET SalesDataByCompany LAST_MOD TO '01/01/2024 08:00'
