Post reply

Contraints when linking tables in a Diagram...

  • April 10, 2006 at 7:21 am

    #172156

    Hi all,

    I am putting together the data schema for my application through the Diagrams tool that is in SQL Server 2000 and each time I create a table

    and link the primary/foreign key columns to another table I get prompted a diagram box with the checkboxes for the following:

    1) Check existing data on creation.

    2) Enforce relationship for replicatin.

    3) Enforce relationship for inserts and updates.

    I currently keep these checked when I create the relationship. Can someone briefly go over these constraints? I take it the first one (1) is saying that if

    I was to use a foreign key in one column, then this value must exist in its referencing table for the row to be inserted?

    Is it worth me putting in these constraints (I take it they are constraints?) early on in the design? Also, if I wish to change these, is the only way to do this

    in the diagram section by double clicking on the link?

    Thanks in advance.

    Tryst

  • April 10, 2006 at 8:09 am

    #631750

    In the time that it takes for someone to explain these you'll make speedier progress if you just look this up in BOL...look under "constraints - in database diagrams"...







    **ASCII stupid question, get a stupid ANSI !!!**

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

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