SSMS - Right-click menu option to "Design" tables configured as Temporal Tables is missing
I am using the new Temporal Table feature on certain tables in my database.
When I navigate to such tables via SSMS Object Explorer, I have found that the "Design" right-click menu option is not present for Temporal Tables. (Or as SSMS labels them, "System-Versioned" tables.)
The "Design" option is, however, still available for NON-temporal tables.
Upvotes: 0<=-=Mar 7 2017 2:10AM=-=>
Thank you for taking time to post this issue!
I can confirm that Design option in SSMS Object Explorer is not available for temporal (system-versioned) tables.
Unfortunately, we do not plan to include a fix for this issue in the upcoming release.
We might include it as an improvement in a future release, though.
How important for you is to have this option available for temporal tables?
Expand the system-versioned table and right-click Columns group. Select New column... the designer will appear! (you don't need to add any column). Do your changes to design and save as usual. Changes will also affect automatically the History table.
I think it makes sense that if it's a table (of any kind) that is should have the ability to be edited with the designer. I'm not sure why really great table features of SQL Server should be treated as second-class citizens.
Joe Bourne commented
SSMS v18.4, the work around is to open "new constraints", delete the constraint it gives you and close the constraint window, then you get to see the table design screen. you can add/remove columns from there... works but clunky.
Tim L commented
[Deleted User] commented
Pretty **** important
Mark Sisson commented
Please add this back. It's a huge waste of time writing custom TSQL just to make small changes. This is a step backwards for SSMS for those of us that use temporal tables all the time.
We manage so many databases for so many different customers that we often use the designer to make these changes. That this feature is now missing is definitely a hindrance. Please add this back for temporal tables!
Travis Kale commented
Considering so many informational items can be discovered through the design tab, this needs fixed. I don't always use the design window to alter the table, I may want to look at the description/extended properties of a column. I don't want to have to write a query to do this.
Not fixed in SSMS v18.0 RTM ...
Still not fixed in SSMS v18.0 Preview 7 ...
Still not fixed in SSMS v18.0 Preview 4 :sad_face:
Dieter Verfaillie commented
We're about 20 release further now. Any plans to include this basic feature?
Klaus Oberdalhoff commented
You ask how important ?
Well that is my personal no 1 BUG (not a missing feature)
Klaus Oberdalhoff commented
this is a "bug" not a "feature" as i see it.
here an ugly workaround i found by chance:
if using temporal tables i always create the temporal table as mytable_history.
So if you open the tree for that table it shows always at first the temporal table name. If you right-click the mouse on THAT temporal table it SHOWS the select nnn rows and edit nnn rows
So if you create the script it obviously contains the same column names - just with wrong "from" so i just delete that string "_history" and execute that. And VOILA i now HAVE my select on the table i wanted ...
This feature is still not available in v17.8.1 of SSMS.
This is an important feature to add; to be able to design and modify a system-versioned temporal table in the SSMS visual designer would be extremely helpful, and would reduce the amount of time required to make changes to temporal tables.