there is a requirement of copying all the tables with data from one db (may be dev) to another db ( Test) .
It can be done as below :
a) Utilizing the metadata tables for creating the automated create table statements as below :
create table db.tablebackup as (select * from (select * from db.table) x) with data;
but as mentioned in the forum , it will have the another issue that back up table will have the default first column as the primary index .
Is there any other way of handling the automatic scripts for the table with identity columns?