Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Foreign key relationship properties

Author  Topic 

irs2k3
Starting Member

22 Posts

Posted - 2007-10-07 : 15:50:36
Hey guys,

I would like to know what the following options means when we set a foreign key relationship between two tables and when to use them ( yes or no):

1- Check existing data on creation or Re-Enabling.
2- Enforce contraint for replication
3- Enforce foreing key contraint


Thx.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-07 : 20:52:33
Did you look at books online first?
Go to Top of Page
   

- Advertisement -