Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Open Database Schema in Visual Studio 2013

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 :

enter image description here

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

enter image description here

this is what I need to get: enter image description here

Thanks everyone in advance !

like image 748
inside Avatar asked Jan 12 '23 01:01

inside


2 Answers

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.

enter image description here

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

enter image description here

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.

like image 79
Dustin Davis Avatar answered Jan 21 '23 17:01

Dustin Davis


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

like image 20
Ranjith Manickam Avatar answered Jan 21 '23 18:01

Ranjith Manickam