Auto Increment missing

Question

I have imported a table from one database to another, the issue is the auto increment ID has now been removed, I want to add the primary key back to the original column on my copied table and get it working again by taking the last max ID when it was working and continuing to add 1 as normal, is this possible.

Thanks P

also check - http://stackoverflow.com/questions/1049210/adding-an-identity-to-an-existing-column — Nenad Zivkovic, Oct 07 '13 at 11:40

score 0 · Answer 1 · answered Oct 07 '13 at 12:23

0

Just Check the Table.Whether Identity is must be there..Remove the identity..So it wil start from 1

The Query DBCC CHECKIDENT('Your Table Name', RESEED, 0)

answered Oct 07 '13 at 12:23

user2854604

1

Auto Increment missing

1 Answers1