Results 1 to 3 of 3

Thread: ER diagram

  1. #1
    Join Date
    Apr 2003
    Posts
    176

    Unanswered: ER diagram

    Is there any tool to generate ER diagram in sql server 2000. If not where can i generate an ER Diagram.



    Thanks.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    You can use the Diagrams tab of your database in Enterprise Manager, but be aware that this shows physical links between your tables, not logical ones.

    So if you link tables in the diagram Enterprise Manager will actually create the foreign keys and constraints, which may not be what you want.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Oct 2003
    Location
    Jordan
    Posts
    28

    Smile ER Design

    Hi

    You can try Quest - QDesigner or Sybase Powerdesigner. They're almost the same and can be used both ways Reverse enginer a database or generate from your own design.
    Firas arramli
    Systems Analyst

Posting Permissions

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