Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

4
  • This appears to be the same as the accepted answer except for the use of a different keyword (and the other one is much better formatted).  Is your answer really different?  Can you explain how?  Is your answer better?  Why? Please do not respond in comments; edit your answer to make it clearer and more complete. Commented Jun 27, 2018 at 15:22
  • @Scott Actually they are a little different: ALTER COLUMN Id AUTOINCREMENT(1001,1) and ALTER COLUMN [Id] COUNTER (8982,1) see the word AUTOINCREMENT and COUNTER but they both work as expected Commented Jan 20, 2020 at 4:18
  • 1
    @willyw: Right; I said “the same … except for the use of a different keyword”. Commented Jan 20, 2020 at 5:17
  • @Scott ops yes you are right... I was reading too fast sorry ;-) Commented Jan 20, 2020 at 5:40