Issue/Symptom/Question

What are TEMP tables for in the database and do they need to be kept?

Environment

• PENTA Database
• TEMP tables created as part of requested changes

Resolution/Fix/Answer

• TEMP tables should be kept
  
  • Original data is stored in the TEMP table and may assist with troubleshooting in the future

Cause 

• TEMP tables are created to back up data that is changed as part of the resolution of a SUPPORT ticket