Copy all fields from one table to another table

Peter Wood
Kilo Guru

Hi All,

We are creating the custom backup tables to store the data.

We are creating the backup tables using script on certain conditions. What we want is to create all the available fields from source table to backup table as it is.

e.g We have incident table and based on condition we are creating the incident_backup table and in incident_backup table I want to create all the fields which are there in incident table.

How we can achieve this using script.

If field is choice field then it should copy all the choices as well in backup table.

 

Thanks in advance. 

5 REPLIES 5

create a Before Query Business Rule and apply the condition in it

If my answer finds you well, helpful, and related to the question asked. Please mark it as correct and helpful.

Thanks
dgarad