CODEWITHSUNDEEP
sqlvisual-studio
Akshay Bhardwaj
Akshay Bhardwaj

Reputation: 65

"Add new table" option missing - Visual Studio 2015

I'm working on Visual Studio 2015 and whenever I try to add a table from the server explorer menu, it only shows two options Properties and Refresh.

There have been answers for this problem, but I have already tried them, like, adding SQL data tools and repairing visual studio.

SQL data tools were already installed and even after repairing the problem persists.

So please suggest me how can I add tables to the database.

Upvotes: 1

Views: 2721

Answers (4)

nayyer
nayyer

Reputation: 1

Download and Install SQL server data from the link given below, https://download.microsoft.com/download/3/4/6/346DB3B9-B7BB-4997-A582-6D6008796846/Dev12/EN/SSDTSetup.exe

After installing the SQL server you will be able to add a new table. Table > right click> Add new Table.

Upvotes: 0

Wajid khan
Wajid khan

Reputation: 872

  1. Close your visual studio.
  2. Download SQL Server Data Tools
  3. Install it in your pc
  4. Then Close if successfully installation.
  5. Now Open your visual studio.

Hope this will help. Enjoy :)

Upvotes: 1

Rohit Chauhan
Rohit Chauhan

Reputation: 1159

Another reason "Add New table" Not showing is you don't have installed SQL server Data Tools.So just go ahed and downlaods SQL server data tool ISO from official Website

https://go.microsoft.com/fwlink/?linkid=863443&clcid=0x409

Install the SQL Server Data Tool And Restart Visual Studio

Upvotes: 0

Akshay Bhardwaj
Akshay Bhardwaj

Reputation: 65

Thanks for the comments, but i solved the problem.

Open the command prompt and type the command:

C:\sqllocaldb create "MyInstance"

MyInstance refers to your sql server instance, it can be v11.0 but for me it was mssqllocaldb .

If it runs successfully, it will show you result stating 'Instance created' and you will be able to add the tables.

But if you get error regarding creation of instance then delete the instance by typing the command in command prompt:

C:\sqllocaldb delete "MyInstance"

and then create the instance.

I hope this helps.

Upvotes: 1

Related Questions