how backup of tables with IDENTITY column

Database
Enthusiast

how backup of tables with IDENTITY column

how can you backup of tables with IDENTITY columns?

1 REPLY
Enthusiast

Re: how backup of tables with IDENTITY column

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

Insert into backuptable sel * from identitytable;