Post reply

How do I produce the relationship diagram in Microsoft Sql Server?

  • August 10, 2021 at 12:17 am

    #3918292

    How do I produce the relationship diagram in Microsoft Sql Server?

    Here is a visual of what I am talking about here:

     

     

  • August 10, 2021 at 10:40 am

    #3918396

    Hi,

    just use your database, and select:

    Database Diagrams

    Right click and create your own new diagram?

    Good luck,

    Andreas

  • August 10, 2021 at 10:49 am

    #3918399

    Are you looking for the Database Diagram mentioned in the below article?

    https://www.mssqltips.com/sqlservertip/6269/sql-server-database-diagram-tool-in-management-studio/

  • August 17, 2021 at 5:23 am

    This was removed by the editor as SPAM

  • August 18, 2021 at 3:40 am

    This was removed by the editor as SPAM

  • August 18, 2021 at 11:24 am

    #3921220

    You use SSMS to do this, but I think the diagram functionality was removed from a couple of versions of SSMS. It is definitely back in the latest version (18.9.2 at the time of this post).

    Be careful when using/saving diagrams using this tool. Changes made in the diagram are actually made to your database so if you're just trying something out or maybe adding relationships to show how things work, SQL is going to make those changes to your actual database if you save.

    If you have access to the latest copy of Visio, it can do ER Diagrams for SQL Server. There are also some other apps/sites that can give you some diagram functionality, though many cost money to do more than a small number of tables.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply