Hey Rick,
A "constraint" does just what it says - it enforces a rule.
A "foreign-key constraint" refers to a type of constraint that, when
placed on a column in one table, makes sure any values in that column
reference a value in a column in a second ("foreign") table.
Basically, if I had the following:
User
---------
UserId
FavoriteColorId
Color
----------
ColorId
I could place a "foreign-key constraint" on User.FavoriteColorId that
referred to Color.ColorId to make sure no values were ever entered
into User.FavoriteColorId that weren't in Color.
-Joe
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200639
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
