How to clone table

[Balaji Munusamy]

My requirement is clone table and export all records into the new table. For example: The main table is 'incident' i want all the fields and records from incident table and to be inserted in 'New table'. And if new record created in 'incident' table it should insert the same record into the 'New table'.

@Sohail Khilji @Ankur Bawiskar @Community Alums 

[Peter Bodelier]

Hi @Balaji Munusamy,

I wonder what the use case behind this is?

There is not OOTB way to do this.

So you'll have to create your table manually, with all fields, and create a Business Rule or Flow, to create the records.

[Balaji Munusamy]

Hi @Peter Bodelier,

 Actually we need 'New table' for reporting and tracking because the Main table is common table for everyone. Is it possible to create 'New table' with Main table as extensible.

[Peter Bodelier]

I still don't really see why you would need to do this.

You can report on incident table. What kind of tracking would you need to do?

[Ankur Bawiskar]

@Balaji Munusamy 

As mentioned by Peter, we would like to know the business requirement around this.

Why to replicate same table along with entire data again?

Is this your case-study or an assignment?

If yes then you can create similar table with similar fields and use flow designer to insert record into new table on incident record insertion

If my response helped please mark it correct and close the thread so that it benefits future readers.