question How to clone a table in SysAdmin forum

How to clone a table

bonsai — Thu, 08 Dec 2022 15:27:13 GMT

I want to duplicate a table with identical fields within the same instance.

You can use the same fields with an extended table, but you don't want the child table's records to appear in the parent table.

There are nearly 80 fields that I plan to create in the table, so it's tough to manually duplicate them.

Anyone know how to clone a table?

Re: How to clone a table

Gunjan Kiratkar — Thu, 08 Dec 2022 16:11:31 GMT

Hi @bonsai ,

You can use below script in background script

The first argument is the source table, the table to be copied. The second argument is the new/target table. The third argument is Boolean: set it to false if you don't want to or need to create the indexes.

cpTable('incident', 'incident_copy', true); function cpTable(strOldTable, strNewTable, bCopyIndexes) { var tu = new TableUtils(strNewTable); var bNewTableAlreadyExists = tu.tableExists(); if (bNewTableAlreadyExists) { gs.print("WARNING: Target Table " + strNewTable + " already exists! Please choose a new target table name"); } else { var gr = new GlideRecord(strOldTable); gr.initialize(); var td = GlideTableDescriptor.get(strOldTable); var tdNewTable = new TableDescriptor(strNewTable, gr.getLabel()); var dbo = new GlideRecord("sys_db_object"); dbo.addEncodedQuery("super_classISNOTEMPTY^name=" + strOldTable); dbo.setLimit(1); dbo.query(); if (dbo.next()) { tdNewTable.setExtends(dbo.super_class + ''); } tdNewTable.setFields(gr); tdNewTable.copyAttributes(td); tdNewTable.setRoles(td); tdNewTable.create(); if (bCopyIndexes) { tdNewTable.copyIndexes(strOldTable, strNewTable); } } }

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

Re: How to clone a table

bonsai — Fri, 09 Dec 2022 08:46:51 GMT

thank you!

I used the post-New York script from the page you provided and it worked!

When using an extended table, there was a bug that the label of the table became the label of the extended table, but it is minor!

Re: How to clone a table

matrixtushar — Wed, 07 Aug 2024 07:35:44 GMT

Hi,

The table should extend the Task table and once the table is created, there is no way we can change it.