Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2006
    Posts
    54

    Unanswered: Database Design Software

    I have been handed a SQL Server database and need to create a database schema.

    Some table joins are not obvious.

    Is there any software (free) that can give me a start on how the tables relate to each other - Ideally a graphical representation.

    Cheers

    Michael.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    In Management Studio, expand the database. Go to Database Diagrams. Create new, add all tables. Once generated, move the tables around to make it easier to read.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jan 2006
    Posts
    54
    Quote Originally Posted by pootle flump
    In Management Studio, expand the database. Go to Database Diagrams. Create new, add all tables. Once generated, move the tables around to make it easier to read.
    Hoping for some software that will actually create the likely joins between tables.

    There are 300 tables, most are likely to be lookups, some might not be used at all.

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Oh dear. So the designer did not create foreign keys? Are you sure of this? Did you try using the diagram?

    BTW - these are not "joins" these are "relationships".

    EDIT - in fact, what does this return?
    Code:
    SELECT    *
    FROM    sys.foreign_keys
    Last edited by pootle flump; 11-21-08 at 07:19.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Quote Originally Posted by pootle flump
    Oh dear. So the designer did not create foreign keys? Are you sure of this? Did you try using the diagram?

    BTW - these are not "joins" these are "relationships".

    EDIT - in fact, what does this return?
    Code:
    SELECT    *
    FROM    sys.foreign_keys
    Did they at least name supposed PK and FK columns the same between fact and lookup tables ?

  6. #6
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by PMASchmed
    Did they at least name supposed PK and FK columns the same between fact and lookup tables ?
    Heh - that was my thought too. One step at a time ATM. Even if they did, can you imagine the data cleaning that will be required implementing the relationships? Eeek!
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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