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