One SEQUENCE, many tables .. need advice

From: Anne Nolan <anolan_at_enabletech.com>
Date: Tue, 03 Jul 2001 14:00:14 -0700
Message-ID: <3B42325E.3A7DCAD8@enabletech.com>

Hi all,

I'm working on designing a whole new database. I've decided to go with surrogate keys generated from sequences for most of the primary keys in the tables.

Is it OK or even advisable to use one sequence for generating all these keys? Or should each table have its own sequence for generating its keys? I presume there is no ultimate upper limit to how big a sequence value can get..is this true?

Thanks in advance for any and all advice on this, and sorry if this is a FAQ. (I did a quick search on this topic, but could find nothing.)

Anne Received on Tue Jul 03 2001 - 16:00:14 CDT