cookieChoices = {};

Wednesday, 4 May 2016

RESEED Identity of all tables

RESEED Identity of all tables


EXEC sp_MSForEachTable '  
  
IF OBJECTPROPERTY(object_id(''?''), ''TableHasIdentity'') = 1  
  
DBCC CHECKIDENT (''?'', RESEED, 0)

No comments:

Post a Comment