One Reason: Because someday you many not be the one who needs to understand.
-------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning ....-----Original Message----- ....From: Matthew Small [mailto:[EMAIL PROTECTED] ....Sent: Thursday, June 02, 2005 11:53 AM ....To: CF-Community ....Subject: SQL relationships .... ....For the past 8 years I've been working with SQL, I've never really ....understood how to use the relational diagrams that use primary and ....foreign ....keys. I just recently found the diagram tool in SQL and I like it for ....laying out my new databases. However, even though I understand the ....concepts, I don't really see the use of connecting the tables together in ....these diagrams, of declaring the foreign and primary keys in these ....things. ....In my programming, I know which tables are related to other tables, but ....why ....is it good to tell the db what these relationships are? .... .... .... ....Thanks, .... .... .... ....Matthew Small .... ....Web Developer .... ....American City Business Journals .... ....704-973-1045 .... [EMAIL PROTECTED] .... .... .... .... .... .... .... .... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:5:159466 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
