Change starting value of Identity column in sql server

Posted Date: 01-Aug-2008	Category: General	Rating:
Author: Koshish	Member Level: Bronze	Points: 2

The code sample contains a command that will change starting value of identity column of tableName to 21234549


DBCC CHECKIDENT (tableName, RESEED, 21234549)

In general, to change to some other name, replace the "21234549" with the appropriate value.

Did you like this resource? Share it with your friends and show your love!

Responses to "Change starting value of Identity column in sql server"

No responses found. Be the first to respond...

Feedbacks

Post Comment:

Notify me by email when others post comments to this article.

Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.

No HTML formatting and links to other web sites are allowed.

This is a strictly moderated site. Absolutely no spam allowed.

Name:	Sign In to fill automatically.
Email:	(Will not be published, but required to validate comment)
	Type the numbers and letters shown on the left.

	Next Resource: Function Keys In Command Prompt
	Previous Resource: Tips for using SSH into iPhone.
	Return to Resources
	Post New Resource
	Category: General

Post resources and earn money!

More Resources

Popular Tags

Tag posting guidelines

Search Tags

Change Identity column starting value . Change starting value of identity column .

My Profile

Active Members
Today

Last 7 Days

more...

Awards & Gifts

Email subscription

About Us Trademark Disclaimer Contact Us Copyright Privacy Policy Terms Of Use Revenue Sharing sites Advertise Talk to Tony John
Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India
2005 - 2012 All Rights Reserved.
.NET and other trademarks mentioned in this site belong to Microsoft and other respective trademark owners.
Articles, tutorials and all other content offered here is for educational purpose only.
We are not associated with Microsoft or its partners.