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?

Version: SQL Server 2016 Management Studio (July 2016)

Thanks!

Setback

Does your login have the permission to create new tables ? – Serge

Permissions problem? Try running CREATE TABLE Test (col1 INT) and see what happens. – Capacious

@DavidG: Result => Command(s) completed successfully. – Setback

Yes! @M.Ali... check the DavidG's comment. – Setback

Just to confirm, did you run that command in the same database where you want to create the table? – Capacious

Yes @DavidG, however the problem occurs with any database! – Setback

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 #38195571 – Fryer

@Fryer the same, SQL Server 2016 express edition – Setback

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 – Fryer

@oneNiceFriend more details in this question! – Setback

What is the compatibility level of the database? – Fryer

Answer 1

This has been reported as a bug:

Microsoft Connect

social.msdn

Fryer

Answer 2

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

Cleora

Answer 3

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.

Augustus