Setting Identity field, seed and increment in a table in Management Studio v18 (2019)

Question

I am wondering if there is a way to set Identity Field, Seed, Increment in Management Studio 2019 (V18.6) just like in Management Studio 2012. I wonder if Transact-SQL is the only way to set Identity seed and increment in Management Studio 2019.

Thanks!

dchan

Answer 1

On SSMS, you can set the Identity Seed and Identity Increment. See the screenshot:

Answer 2

Hi @Dan Chan ,

>I wonder if Transact-SQL is the only way to set Identity seed and increment in Management Studio 2019

In addition to using T-SQL statements, you can also set/edit the Identity field when create a table or design the table by SSMS UI.

But it should be noted that when using SSMS UI to Design the table, the SSMS UI is not allowed to make major changes to the table by default, usually get error-"Saving changes is not permitted....". You should change a option as mentioned in the link above.

Answer 3

@Guoxiong .... I saw your screenshot in SSMS 2012, but not in SSMS 2019. Please see the attachment in my original post. I don't know how to make the attachment show up without clicking on it.

@Cris Zhan-MSFT ..... Understood. But, is there a way to set identity seed and increment in SSMS 2019 UI?

dchan

Answer 4

@Guoxiong

And the Identity Seed and Increment option cannot be found in the Properties window.

dchan

Answer 5

@Viorel @Guoxiong

Thanks for you all's patience! I got it at last.
It is at the same place where it has always been. I simply did not see it somehow!!!

THANK YOU!

dchan