All Forums Database
wambli 5 posts Joined 02/12
16 May 2012
how backup of tables with IDENTITY column

how can you backup of tables with IDENTITY columns?

16 May 2012

create a table new by executing the DDL of the original table ( remove the identity clause from that).

 

Insert into backuptable sel * from identitytable;

Regards
Chanchal Preet Singh

You must sign in to leave a comment.