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

- Newsfeed
- Find People
- More
- - Products By Bayt.com
    
    Bayt.com
    
    Shagheel
    
    Specialities
    
    Learning
    
    Companies
    
    Salaries
    
    People
    
    Blog
    
    Podcasts
- - العربية
- Use Our Mobile App
  
  Get contacted by recruiters directly with our newest chat feature!
  
  Download Now

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 (3) 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)

Upvote (0)

Downvote Reply () Report

Popular Searches

Engineers Jobs Sales Executive Jobs Accountant Jobs Software Engineer Jobs Engineering Technicians 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)