How to create a temporary table and store it in another table before deleting and still have access to this information in a field containing the list of this table the other on bubble io

Need help Database
1

how to create a temporary table and store it in another table before deleting and still have access to this information in a field containing the list of this table the other on bubble io

2

What exactly are you trying to achieve? Move data to new table and delete old as an update to your apps data structure? Or is this user facing in some way?