CODEWITHSUNDEEP
sql-servervisual-studiosql-server-express
MKANET
MKANET

Reputation: 663

Visual Studio Ultimate 2013: Server Explorer 'Add New Table' and 'New Query' menu items missing

What's wrong with this picture? In older VS versions, I used to see 'Add New Table' and 'New Query' when I right-clicked Tables

Hopefully, someone where has some experience with Visual Studio 2013 and SQL Express databases.

Visual Studio 2013 Ultimate - Server Explorer - Tables - Add New Table Missing

Upvotes: 3

Views: 4597

Answers (3)

Ziyaul Sheikh
Ziyaul Sheikh

Reputation: 1

If you only see Refresh and Properties when you right click on Tables in Server Explorer, you probably need to install SQL Server Data Tools from http://msdn.microsoft.com/en-us/data/hh297027

Upvotes: 0

Umut D.
Umut D.

Reputation: 1846

i also hate this problem. But it has an easy solution: Run your Visual Studio 2013 installer > select MODIFY > check SQL Server Data Tools option. If you don't have an installer, you can visit this page to download SQL Server Data Tools.

Upvotes: 2

MKANET
MKANET

Reputation: 663

Running a repair via Windows 'Programs and Features' resolved this issue. I Had a feeling the problem would be fixed when the repair needed the system to reboot for the repairs to complete.

Upvotes: 1

Related Questions