Database Diagram

  • Hi I have a database

    I want to see the database diagram With relation ship(i.e) navigation flow

    I my db diagram it doesn't display

    also my tables dont have Fk it has only Pk(Primary Keys)

    Pla give me the naviation

    To see the relation ship of tables and keys

    withregards

    Lee

  • I would download the 14 day of the red gate tool, specifically the documentor as it gives all that info and more in a dynamic HTML format which can be viewed at any time, with or without the documetor once you have created the initial file..

  • There is no way to get the navigation flow, if you have not specified the FKs.

    If wish to see the whole database in one document. see this link

    http://www.codeproject.com/KB/database/SQL_DB_DOCUMENTATION.aspx

    Regards,
    Nitin

  • So did you try what I laid out in the post you put up yesterday?

    http://www.sqlservercentral.com/Forums/Topic641528-149-1.aspx

    If it didn't work, what went wrong?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Hey Lee,

    As Grant has mentioned, you can create diagram using management studio. But It will give relations only if you have specified the FKs. If you didn't specify the FKs (as per your post), then there is no way to create relationship diagram using management studio.

    You have to do manual exercise to create the diagram using some UML tool.

    Regards,
    Nitin

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

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