dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: RESEED Identity Columns of All Tables

See how to loop through all the tables and execute the DBCC CHECKIDENT command.


advertisement

You can RESEED Identity Columns of all tables by using sp_MSForEachTable to loop through all the tables and executing the DBCC CHECKIDENT command if the specific table has an identity column:

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

 

Visit the DevX Tip Bank

 



   
Thanks for your registration, follow us on our social networks to keep up-to-date