Results 1 to 3 of 3

Thread: A script or a code to give me all the entity relations of my database

  1. #1
    Join Date
    Oct 2003
    Posts
    24

    A script or a code to give me all the entity relations of my database

    Hi,

    I would be grateful if you could point me to a SQLserver script that will give me the "Entity Relation Diagram" of my database.

    Thanks in advance.

    Regards,

    Albert

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Don't know any script that can generate relation diagram, but can try sp_pkeys and sp_fkeys for table relation info.
    Last edited by rmiao; 12-28-2004 at 12:38 PM.

  3. #3
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Use any tool like ERWIN or ER studio and point to any database and do reverse engineer.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •