Copy all fields from one table to another table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-08-2024 11:47 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-09-2024 02:26 AM
create a Before Query Business Rule and apply the condition in it
Thanks
dgarad