SQL Server 2016 Express Management Studio cannot design a new or existing table

Question

In Microsoft SQL Server 2016 Express Management Studio (July 2016) cannot design a new or existing table.

Image 1: click on the tables node. Where is the menu option to add a new table?

Image 2: Click on existing table. Where is the menu option to edit an existing table?

Thanks!

Permissions problem? Try running `CREATE TABLE Test (col1 INT)` and see what happens. — DavidG, Jul 05 '16 at 22:02
Just to confirm, did you run that command in the same database where you want to create the table? — DavidG, Jul 05 '16 at 22:37
What version of SQL Server is the database that you are trying to modify? SSMS for SQL Server 2016 will not maintain databases of 2008R2 or before http://stackoverflow.com/questions/38195071/create-new-table-is-not-visible-on-ssms-2016-for-sql-server-2008/38213611#38213611 — Mike, Jul 05 '16 at 23:00
OK, I have deleted my answer since it wasn't relevant to you, but i will leave the comment to redirect those who may have that issue — Mike, Jul 05 '16 at 23:14

score 3 · Accepted Answer · answered Jul 06 '16 at 08:22

3

This has been reported as a bug:

answered Jul 06 '16 at 08:22

Mike

score 2 · Answer 2 · answered Jul 15 '16 at 09:42

2

Microsoft released a hotfix for this issue already. You can download it here: https://msdn.microsoft.com/en-us/library/mt238290.aspx

answered Jul 15 '16 at 09:42

score 1 · Answer 3 · edited Jul 11 '16 at 17:47

1

If you uninstall the July edition and re-install the June edition, things will be back to "normal" for you. You do lose the Azure support, however.

edited Jul 11 '16 at 17:47

Laurel

answered Jul 11 '16 at 17:43

Chris Z.

3 Answers3