Greetings,
When the table object editor is open, and the column properties pane is open, it would be great if in the IDENTITY section, it showed what the current SEED and INCREMENT values are for that table.column. Provided the column type is set to IDENTITY of course.
It would be even better if the SEED could be changed, and then UPDATE Database button was pressed. Or maybe in the Database Explorer context menu, if the appropriate column was clicked on, there was a way to RESEED the IDENTITY interactively.
Right now, I use T-SQL to change my seed value, which isn't hard. It would be an improvement if it could be done through the User Interface.
[Feature Request] Change Identity seed in UI
-
- Posts: 33
- Joined: Tue 06 Dec 2016 19:49
Re: [Feature Request] Change Identity seed in UI
There are the 'Seed' and 'Increment' properties for a column in the right part of Table Editor.
-
- Posts: 33
- Joined: Tue 06 Dec 2016 19:49
Re: [Feature Request] Change Identity seed in UI
Yes. Those are the fields I am referring to. I just tried this morning to change the seed value using that field and it did work. I had assumed they didn't work since they don't seem to change from their initial or user adjusted values. The seed value does not reflect what the current seed is. That was the reason for my confusion.
Given that, it would be nice if the seed value reflected the current value. Since you have a bigger picture of the feature set, there may be a use case for only showing the initial values.
Thanks for the clarification.
Given that, it would be nice if the seed value reflected the current value. Since you have a bigger picture of the feature set, there may be a use case for only showing the initial values.
Thanks for the clarification.
Re: [Feature Request] Change Identity seed in UI
Could you please clarify whether you are referring to last_value? If so, for example, in SSMS there is no such a property. What do you need it for?
In case you don't see the actual values of 'seed' and 'identity', please let us know whether you were changing these values with a script. After execution the script, please try clicking the 'Refresh Object' button in the table editor.
In case you don't see the actual values of 'seed' and 'identity', please let us know whether you were changing these values with a script. After execution the script, please try clicking the 'Refresh Object' button in the table editor.
-
- Posts: 33
- Joined: Tue 06 Dec 2016 19:49
Re: [Feature Request] Change Identity seed in UI
Code: Select all
IDENT_CURRENT( 'table_name' );
Code: Select all
DBCC CHECKIDENT( 'table_name', RESEED, <new value> );
Regardless, to answer your last question, when the table is altered with the table editor, the 'seed' and 'increment' values are the same as defined in the T-SQL script for table creation.
At the time of my original post, I was curious if the table editor displayed the last value for the identity when the object was refreshed. It does not. I was also curious if I could change the seed and increment with the table editor. That certainly is possible, but only advisable under limited conditions, lest the identity value becomes useless as a primary key.
Re: [Feature Request] Change Identity seed in UI
Thank you for the reply.
We will take this into account.
We will take this into account.