How to re-identity database table column to continue from last identity record?

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Next Question:
I have a table column eg (invoice) invoice its(is identity is on increment by on...
Posted by:
Pathan Zarrar Khadar Khan
10-October-2016

SQL Server 2000 2008

Question added by Moaiad Hawash , Senior .Net Developer and Project System Analyst , Trainera
Date Posted: 2014/07/19

Upvote (0) Views (4) Followers (1) Answers (1) Report Question

Write an Answer
Register now or log in to answer.

1 Answers

by mojtaba amiri , Senior Software Developer , Kharazmi IT Corp.

You can use checkident command like this:

DBCC CHECKIDENT (orders, RESEED,999)

Downvote Reply () Report

Popular Searches

Engineering Technicians Jobs Engineers Jobs Sales Executive Jobs Accountant Jobs Software Engineer Jobs

Write Your Answer

More Questions Like This

how to Fix a SharePoint database problem ?
Top Answer: Hi, You can also use the Sharepoint Recovery Tool by DataBaseFileRecovery. With this utility, you can eas ... See More

Answers (2)
How to insert deleted keys in a table where there is an identity(1,1) column in a table, without disabling identity constraint?
Top Answer: If we have TableA with ideantity(1,1) -Generate a new script for TableA without identity(1,1) to a column ... See More

Answers (8)
How to create a new table in SQL server 2000,2005 & 2008 from an existing table without copying the records from previous table?
Top Answer: You mean you just need to copy table with structure right: if so create a table <newtable> as selec ... See More

Answers (3)
What is the difference between internal table and Database table ?
Top Answer: Intenral table is a local table which will be available at runtime only where as database table will hold ... See More

Answers (7)

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.