How to clone a table with records

[cpinedatx94]

I want to create a exact duplicate of a current table and its records. How can i about doing this? Is there any way of doing this wayout scripting? Like a button that just lets me make a copy? Or do i need to write a script?

[AshishKM]

Hi @cpinedatx94 ,

There is no direct option for clone/copy a table structure and data. You have to write some code.

Refer this below 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0656519

-Thanks,

AshishKMishra

[Tony Chatfield1]

Hi, can you clarify the business drivers\use case behind this requirement, as the duplication of records\data does not normally result in value add to the business.

There are a few community posts that cover creating a table via script, but this may not be best practice as is not driven by vendor published documentation.

basic process would be create
Table

ACL's
Server side scripts (BR's)
UI functions (UI policies\client scripts)
Default form\list views - if the table is extended from another, opening list\form view results in a copy from the parent list\form.
Then copy your data

[cpinedatx94]

My current table has MANY inactive technicians that need to be deleted but we don't want to do delete them completely, (we still need them for record keeping). So we want to create a copy for record keeping and then remove the necessary records from the original table.

[Ashir Waheed]

Hi @cpinedatx94 

OOB this is not achievable and not recommended for many reason. You can do the following below methods

1. You can either create a new table that will extend the table you are trying to clone. Then you can export the data from the parent table and re-import the data into the child table.

2. You can refer here on the ServiceNow Support Document How to create a copy of a table.

Regards,

Ashir Waheed