Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

Reseeding an Identity Column - SQL Server

RSS
Modified on Mon, Dec 03, 2012, 8:02 AM by Administrator Categorized as SQL Server
DBCC CHECKIDENT("MyTable", RESEED, 1)
DBCC CHECKIDENT("MyTable", RESEED)

Taken from http://www.sqlservercentral.com/articles/DBCC+CHECKIDENT/94559/

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2018, Patrick Jasinski.