Post reply

Diagrams....

  • October 16, 2006 at 12:23 pm

    #170684

    Can someone help me understand the purpose of using the diagrams portion of SQL Server? Does it relate to views? Help...I'm having a hard time figuring it out.

  • October 16, 2006 at 2:36 pm

    #666075

    No it is not related to Views it let you map your tables and relationships, in 2000 you just add the relationships, but you also know you have to define the Keys Primary/Foriegn in your tables. 

     Views are actually query rewrite almost like stored procs but persisted, now SQL Server 2005 comes with the in memory version called CTE(common table expressions).   Hope this helps.

    Kind regards,
    Gift Peddie

  • October 16, 2006 at 8:16 pm

    #666100

    Be aware that when you change a diagram and save it, it actually updates your database to match... diagrams are really a form of somewhat anorexic data models.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 3 posts - 1 through 3 (of 3 total)

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