CODEWITHSUNDEEP
c#sql-servervisual-studio
Niko
Niko

Reputation: 4448

Microsoft SQL Server, creating new table in server explorer

For a C# programming assignment I have to create a table in Microsoft SQL Server. I have Visual Studio 2013 and Microsoft SQL Server 2012 freshly installed. As I installed it I specified my user for admin access (this is on a laptop with only my user anyway). I can't seem to be able to fully follow my teacher's instructions for the assignment:

  1. Create a new WPF project called StudentDb
  2. Open Server Explorer ( View > Server Explorer )

  3. Right click on Data Connections > Create New SQL Server Database The Create New SQL Server Database window opens

  4. Select a Server name (default: .\SQLEXPRESS)

  5. Choose Windows Authentication
  6. Enter College as the new database name

  7. Click OK

  8. In Server Explorer you’ll find a new Database listed under Data Connections

  9. Expand the College Database (by clicking the triangle left of the College database)
  10. Right click Tables > Add New Table

On number 4, the only server that appeared was "MORTHOS" which is my computer name. (I am hoping that this is arbitrary). I was able to create a new DB named college. When I get to 6 I find that my progress grinds to a complete halt. I only have the options Refresh and properties and can't see where to add a new table as pictured here:

Tables right click

I know it has a valid connection, because it was able to successfully create the College database. I can even confirm that it has a good connection when I click "test":

enter image description here

Can someone please tell me what I am doing wrong?

EDIT: in SQL Server Management Studio I do see myself under the logins:

enter image description here

Upvotes: 6

Views: 15741

Answers (3)

Nathalie
Nathalie

Reputation: 61

Use update after you create the table, don't use save

enter image description here

Upvotes: 6

likekeustc
likekeustc

Reputation: 71

I ran into the similar "Create Table" not showing up (only "refresh" and "Properties" are left) for a right click on the empty Table in Data Connections.

I installed SQL server data tools and it is working! Thanks!

Upvotes: 0

Samarth Agarwal
Samarth Agarwal

Reputation: 2134

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: 7

Related Questions