Home / server / Questions / 135645
Accepted
Ice
Asked: 2010-04-23 22:00:45 +0800 CST

Best approach to change from identity(1,1) to identity(1,5)

  • 772

i have some big tables with several million records and want to change the identity(1,1) to identity(1,5). what would be the best way to do that?

sql-server-2008

1 Answers

  1. Best Answer

    No answer yet?

    i see a way like this on a in place migration:

    SELECT *
INTO Backup_Table
FROM SOURCE_Table
GO
DROP Source_Table
GO
CREATE Source_Table (SerialNo IDENTITY(1,5) NOT NULL, ...)
GO
INSERT Source_Table(*)
SELECT *
FROM Backup_Table
GO

    This has to be done for all the tables in a database.

    What do you think?

    • 0