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?
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.