CODEWITHSUNDEEP
sql-server
Al F.
Al F.

Reputation: 21

SQL Server 2016 Management Studio : no "New Table" option

I installed SQL Server 2016 Express edition. Everything seems to work fine except there's no "New Table" option to create a table (Image). There are 2 empty folders, System and File tables. Any ideas what is missing or what is being done wrong? Right-clicking on File Tables does not show a New Table option to create one

enter image description here

Upvotes: 1

Views: 1679

Answers (1)

Dan Guzman
Dan Guzman

Reputation: 46203

There is a known issue reported on Connect where some of the SSMS Object Explorer context menu items are unavailable in the SSMS July 2016 Update when connected to a SQL Server Express or LocalDb edition. As Microsoft noted in the Connect comments, a fix is planned for the July update. An interim workaround is to uninstall the current July 2016 update and install the previous June 2016 Update instead. Alternatively, one could use Developer Edition instead of Express or LocalDb.

Upvotes: 1

Related Questions