Subject | RE: [ib-support] Changing field all places |
---|---|
Author | Alan McDonald |
Post date | 2003-02-21T13:06:01Z |
If you've heard it a lot (as I'm sure you are right.. then you must have
missed the many very full explanations as to why... You'd be better off
doing a search on "primary key" on the yahoo list and you'll get plenty of
info back
Alan
-----Original Message-----
From: Joe Martinez [mailto:joe@...]
Sent: Friday, 21 February 2003 7:30 PM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Changing field all places
explanation of why. If you can guarantee uniqueness of the PK, and use ON
UPDATE CASCADE, then why not let it have "business meaning"?
-Joe
To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
missed the many very full explanations as to why... You'd be better off
doing a search on "primary key" on the yahoo list and you'll get plenty of
info back
Alan
-----Original Message-----
From: Joe Martinez [mailto:joe@...]
Sent: Friday, 21 February 2003 7:30 PM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Changing field all places
>a) never use a PK which has "business meaning"; use a generated PK;I've heard this a lot here, but I don't think I've ever heard an
>b) never ever let your end users touch the PK of any table.
explanation of why. If you can guarantee uniqueness of the PK, and use ON
UPDATE CASCADE, then why not let it have "business meaning"?
-Joe
To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/