Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Initialization

Status
Not open for further replies.
sgueper

sgueper

Programmer
May 2, 2002
18
0
0
ES
I Would like to initialize a column identity after deleting all records and I don't know how to do it.

Thank you

Silvi

 
Sort by date Sort by votes
You use DBCC CHECKIDENT to reinitialize it.
DBCC CHECKIDENT('table name', RESEED, 1) will set the seed back to 1.
 
Upvote 0 Downvote
Thank you very much

I don't know how to do it
where i have to do it to initialize the index?

Thank you again

Silvi
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top