Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --reset identity values to 0 if you have deleted a large number of rows and want to reset. Run again to update to current number of rows
- USE [DB_NAME};
- EXEC sp_MSforeachtable @command1 = 'PRINT ''?''; DBCC CHECKIDENT(''?'', RESEED)'
- GO
Advertisement
Add Comment
Please, Sign In to add comment