1

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

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Al F.
  • 21
  • 3
  • 1
    Possible duplicate of ["Create new table" is not visible on SSMS 2016 for SQL Server 2008](http://stackoverflow.com/questions/38195071/create-new-table-is-not-visible-on-ssms-2016-for-sql-server-2008) – Arulkumar Jul 09 '16 at 05:26
  • In my case there is no older version of SQL Server. I installed SSMS 2016 for SQL Express 2016 for the first time. There must be a bug. I might have to restore Windows to an earlier version and install SQL Express 2014. – Al F. Jul 09 '16 at 05:38
  • If this is the July release it may be a bug – Mike Jul 09 '16 at 05:58
  • Yes it is the latest downloaded July 8. – Al F. Jul 09 '16 at 06:02
  • 1
    Based on the screenshot... you need to right click on `Tables`, not `FileTables`.... unless you want to create a file table? – Nick.Mc Jul 09 '16 at 07:35
  • I should have made the screenshot right-clicking on Tables, it gives exactly the same result you see for the FileTables. No "New Table" in either case. – Al F. Jul 09 '16 at 09:24

1 Answers1

1

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.

Dan Guzman
  • 43,250
  • 3
  • 46
  • 71
  • Thanks for the info. I have also experienced with 2 different computers in 2 different locations connection problems when files are being downloaded to be installed. The installation of Express 2016 is suddenly aborted with a "Ooops.." message about connection problem. It is quite frustrating and a waste of time. – Al F. Jul 09 '16 at 20:39
  • I installed "SSMS SQL Server Management Studio 17.5" and I was able to see the other tables option. (Table...) It was not working with SSMS 2016. – ssinfod Feb 22 '18 at 17:51