SQL Database Design » 12. Auxiliary Tables » 12.2 Sequence Tables

12.2 Sequence Tables

Sequence tables do not belong to the group of lookup tables (at least to Celko's classification in the book Joe Celko's SQL for Smarties: Advanced SQL Programming). Sequence tables use a numeric primary key to identify rows. At its core they are similar to enumerated types discussed in the 8.3 Enumerated Types section. Sequence tables add reusability to DBMSs which do not have reusable ENUMs.

In the current version of this paper, this section is a to-do. Please refer to Joe Celko's SQL for Smarties: Advanced SQL Programming for more information.

Last updated: 2010-08-04