locked
Create diagram from existing database RRS feed

  • Question

  • Is it possible to create diagram from existing database? Need to understand the schema of database which has no documentation. So would like to create diagram for that database.
    Thursday, October 22, 2015 8:21 PM

Answers

  • Hi Amit,

    Yes you can create database diagrams in SQL server. See the link below to find how to create one

    https://msdn.microsoft.com/en-us/library/ms189078(v=sql.110).aspx

    Cheers

    Bhanu

    Thursday, October 22, 2015 8:27 PM
  • Is it possible to create diagram from existing database? Need to understand the schema of database which has no documentation. So would like to create diagram for that database.

    Yes, it's possible. Here's a step by step visual of what to do:

    Right click and choose New Database Diagram

    Add any tables you want to see in the diagram. Don't worry if you miss a table, you can add them later.

    You're done! Now work with the diagram as needed.

    I hope that helps!!


    I hope you found this helpful! If you did, please vote it as helpful on the left. If it answered your question, please mark it as the answer below. :)

    Thursday, October 22, 2015 10:07 PM

All replies

  • Hi Amit,

    Yes you can create database diagrams in SQL server. See the link below to find how to create one

    https://msdn.microsoft.com/en-us/library/ms189078(v=sql.110).aspx

    Cheers

    Bhanu

    Thursday, October 22, 2015 8:27 PM
  • Is it possible to create diagram from existing database? Need to understand the schema of database which has no documentation. So would like to create diagram for that database.

    Yes, it's possible. Here's a step by step visual of what to do:

    Right click and choose New Database Diagram

    Add any tables you want to see in the diagram. Don't worry if you miss a table, you can add them later.

    You're done! Now work with the diagram as needed.

    I hope that helps!!


    I hope you found this helpful! If you did, please vote it as helpful on the left. If it answered your question, please mark it as the answer below. :)

    Thursday, October 22, 2015 10:07 PM
  • Thanks for replying.

    I know how to create database diagram but would like to create database diagram for existing database with relationships among tables. Pictorial representation of database schema will make understanding the schema easier. I don't want to create or edit the schema.

    Sorry if my query is not clear enough.

    Friday, October 23, 2015 9:01 AM
  • I found the answer to my query:

    http://sourceforge.net/projects/dbdesigner-fork/

    Sunday, October 25, 2015 10:26 AM
  • I know how to create database diagram but would like to create database diagram for existing database with relationships among tables. Pictorial representation of database schema will make understanding the schema easier. I don't want to create or edit the schema.

    Sorry if my query is not clear enough.

    A database diagram is based on an existing database and shows the relationships between tables graphically.  What is unclear about your question is why that tool isn't sufficient for your needs.


    Dan Guzman, SQL Server MVP, http://www.dbdelta.com


    Sunday, October 25, 2015 11:27 AM
    Answerer
  • Apologies, after looking at the SSMS database diagram carefully I found it do creates ERD.

    thanks all for your help!

     
    Sunday, October 25, 2015 12:44 PM