SQL Server: unable to save the changes after applying the Identity key on table

Question

While I am trying to apply identity column on a table, I can't save the changes; while trying to save, I'm getting an error shown here:

enter image description here

Pretty straightforward error. You need to drop and recreate the table to make this change. — Jacob H, Aug 08 '17 at 12:53
In the future, please copy and paste error messages into your question *as plain text*. Don't post images of text. — Cody Gray - on strike, Aug 08 '17 at 13:04

score 1 · Answer 1 · edited Aug 08 '17 at 13:04

1

See Options in SQL Server Management Studio

edited Aug 08 '17 at 13:04

marc_s

answered Aug 08 '17 at 12:55

Thanks to everyone (@SQLAndOtherstuffGuy AND @ marc_s)it's working now – Naresh AR Aug 08 '17 at 13:28

1 Answers1