Rank: Newbie
Groups: Member
Joined: 3/24/2008
Posts: 1
Points: 0
|
The identity column in my db (w/ 1&1) is also my primary key column. I have been testing code, but would like to now 'start from scratch.' Which, to me, means having new records start with 1. What is the best way to do this?
(I know it is an unnecessary step, it's just my Obsessive Compulsion sneaking out.)
TIA
Topper
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
Try to execute the following T-SQL script: Code:DBCC CHECKIDENT (yourTableName, RESEED, 1)
|