Results 1 to 4 of 4

Thread: Domain model

  1. #1
    Join Date
    Jan 2006
    Posts
    119

    Unanswered: Domain model

    HI,
    I am on a new project and just trying to get my head around the domain model. Has anyone any good tips for how I could get all the foreign keys in a schema quickly?

    Or, is there any tool which will show me a visual version of my schema? Thanks.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I strongly recommend SQL Spec for this kind of "discovery" and for other purposes as well. The author of SQL Spec is an old friend of mine who stops by DBForums occasionally as Jezzemine.

    SQL Spec can generate documentation files from many ODBC/OLEDB database formats. This documentation can be presented as web pages, or in many cases as a simple click-able help file.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Jan 2006
    Posts
    119
    Thanks Pat. I ended up using SqlServer's Database Diagrams.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    That will work. I'm biased because the developer of SQL Spec pays close attention to the user's needs, so it has literally evolved to suit my needs in many cases.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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