Re: Surrogate Key Semantics
From: -CELKO- <jcelko212_at_earthlink.net>
Date: 12 Nov 2005 09:30:25 -0800
Message-ID: <1131816625.610272.96100_at_f14g2000cwb.googlegroups.com>
Date: 12 Nov 2005 09:30:25 -0800
Message-ID: <1131816625.610272.96100_at_f14g2000cwb.googlegroups.com>
Let's get back to the basics of an RDBMS. Your questions are all based on the wrong mental model.
Read some of Dr. Codd's stuff on this. BY DEFINITION, you cannot name a surrogate key because it is hidden from you. Rows are not records; fields are not columns; tables are not files.
RDBMS uses the terms "referenced" and "referencing" tables. And it does not say HOW that referencing is done. So anything like what you call a surrogate will depend on the implementation, not on RDBMS. Received on Sat Nov 12 2005 - 18:30:25 CET