Well here is my thought. As far as my DB is concerned I fully use creating a pri key and foreign key relationships where needed on all my tables. This helps so much in avoiding someone delteting something from one table that relies on something in another table. Another reason for doing this is that I use SQL 2K and use the diagram feature alot since I have several tables and I can see how each table relates to the others in the schema, as you mentioned. Another reason for pri keys is the aility to index that key for tables such as a zip codes. If you have say 80,000 zip codes, you can index that table and gain measurable increase in performance in doing searches from it.
Just my $.02 There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown ----- Original Message ----- From: "Gyrus" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 09, 2002 8:52 AM Subject: Re: Defining internal DB relationships necessary? > > Are you sure that the "relationships" are only used in the Access GUI? My > > understanding is that they were true constraints. > > You're right, I believe - only I've never had a single problem > so far with not defining them inside the DB (apart from PK's, > which Access forces, and I've got into the habit of defining > by default). > > "So far" is probably the operative part of this, though! I'm > incredibly thorough with my code that inserts data, but > I appreciate that I should get into the habit of defining > relationships explicitly. > > I was asking really to make sure I didn't get any replies going, > "Ohmigod!! You haven't defined the relationships!! All your > sites are about to crash!" Well, as I said, nothing bad so > far, but will bear this advice in mind... > > cheers, > > - Gyrus > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > - [EMAIL PROTECTED] > work: http://www.tengai.co.uk > play: http://www.norlonto.net > - PGP key available > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
