Visual Studio 2015 SQL Server Data Tools missing "Add Table" option

Question

I have added a localdb to my project and trying to add tables to it. But I could not see 'Add Table' item on the menu, there are only 'Refresh' and 'Properties' items. According to the Microsoft SSDT is coming preloaded with VS2015, but there is no option to add a new table. Am I missing something?

Answer 1

Instead of using "Server Explorer", use "View-->SQL Server Object Explorer".

Alternatively you could create an SSDT project, add your tables to the project and then deploy, that would be the correct way to do it! Ed

Answer 2

I have added a localdb to my project and trying to add tables to it. But I could not see 'Add Table' item on the menu, there are only 'Refresh' and 'Properties' items.

To resolve the issue :

Go to Control Panel and try repair the software.

Do not forget to reboot the machine .