Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: NextNumbers Tables

Re: NextNumbers Tables

From: --CELKO-- <71062.1056_at_compuserve.com>
Date: 7 Feb 2003 11:32:40 -0800
Message-ID: <c0d87ec0.0302071132.5ae0f43a@posting.google.com>


>> Any more thoughts on a next numbers table for surrogate keys? <<

Don't do it; look for a natural key. You have no checkdigit, no way to verify the key against the reality you are modeling. No way of knowing if a gap in the numbering is real or an error. Received on Fri Feb 07 2003 - 13:32:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US