locked
Why database diagram is not availabe in visual studio 2013? RRS feed

  • Question

  • User-67874579 posted
    I can not find diagram in order to create a new diagram and create relations between tables ..:. In other way how to creat relations between tables in visual studio 2013
    Friday, January 31, 2014 3:07 AM

All replies

  • User-166373564 posted

    HI siamand

    To create a relationship graphically

    1. In Database Designer, click the row selector for one or more database columns that you want to relate to a column in another table.

    2. Drag the selected column(s) to the related table.

    3. Two dialog boxes appear: Foreign Key Relationship and Tables and Columns, with the latter appearing in the foreground.

    4. Relationship name has a system-provided name in the format FK_localtable_foreigntable. You may change this value.

    5. Verify that Primary key table specifies the correct table.

    6. The grid lists the local columns and their matching foreign columns. You can add or remove table columns or change mappings.

    7. Choose OK.

      The Foreign Key Relationship dialog box appears. Selected Relationship shows the relationship you have created.

    8. Change properties for the relationship in the grid.

    9. Choose OK to create the relationship.

      Database Designer shows a relationship between the columns you chose.

    Further information:

    How to: Create Relationships Between Tables: http://msdn.microsoft.com/en-us/library/zed0k41d.aspx 

    Creating a Relationship between Data Tables: http://msdn.microsoft.com/en-us/library/ms171915.aspx 

    Angie Xu 

    Tuesday, February 4, 2014 11:53 PM
  • User-67874579 posted

    thank you very much for your kind replay, but the problem is i can not drag and drop cloumns, in visual studio 2010 you can create diagram and the tables into it and from there you can easily drag and drop columns and create relations .. but in 2013 i can not find it .

    https://drive.google.com/file/d/0B7m7kMedJ_QcNDAzLUtnOHJHeHc/edit?usp=sharing 

    Regards

    Wednesday, February 5, 2014 1:57 AM