Open Database Schema in Visual Studio 2013

Question

I have already spent couple hours for that trying to find by myself, but no luck so far...

I need to open my db table in schema view so I can add relationships for my tables.

This is what I have now :

This is how it used to be in old visual studio:

this is what I need to get:

Thanks everyone in advance !

Solution 1

Connect to the server via Server Explorer then navigate to the table that will be used as the foreign key. Right click and select Open Table Definition.

Once it's loaded, go to View -> Toolbars -> Table Designer and click it if it isn't already checked.

Next, click on the Relationships icon

From there use the following links for more information on using the relationship tool.

How to: Create Relationships Between Tables

Foreign Key Relationships Dialog Box

Note: These options were not available in VS2013 SKU's Pro and Express (for me). Premium and Ultimate had them. VS2012 Pro had them available.

Solution 2

Select the Database file (*.mdf or *.sdf) in Solution Manager then double click the database file. The Server Explorer is opened database connection. Then till down the database and tables to see the tables. Finally select table then Right click and select Open Table Definition.

Refer the above post image....

In this Server Explorer you can see the Database and it's Schema. Schema is like tables, views, stored procedures, etc...

Also you can change the table and its contents. You can Alter Table Columns, Add Tables and Insert Table Records and Update Table Records, etc...

Comments

[LaserBeak]

I have the same problem as the OP, except for me, after I enabled the table designer buttons, they remain disabled no matter which table I open via 'open table definition'.