Change starting value of Identity column in sql server

Posted Date: 01 Aug 2008	Resource Type: Tips	Category: General
Author: Koshish	Member Level: Silver
Rating:	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.

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

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

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

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

Post resources and earn money!

More Resources