Advertiser Disclosure

Download our iPhone app

TODAY'S HEADLINES | ARTICLE ARCHIVE | FORUMS | TIP BANK

Specialized Dev Zones

Research Center

eBook Library

.NET

Java

C++

Web Dev

Architecture

Database

Security

Open Source

Enterprise

Mobile

Special Reports

10-Minute Solutions

DevXtra Blogs

Slideshow

Python Wonderwords Library: Random Words and Sentences

How to Split Strings in Java

Python Logical Operators

How to Use the StringJoiner Class in Java

How to Find the Status of Threads in Java

Tip: Reseed All Autonumber Fields in All Tables

Learn more about a query that will allow you to reseed all auto-numbered fields.

by Hannes Du Preez

May 27, 2019

Reseed all Autonumber fields in all tables with the following query:

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