ed Di

• Apr 18th, 2006

 

They're all lookup tables.  After you load a table what's left to do but "Look up" the information at a later time. It's what database is all about; storing information for later retrieval.

You probably have something else in mind, like some special table in a special situation. lookup table is too generic.

Mohammed Mushtaq Momen

• Jul 23rd, 2006

 

Lookup tables are like constraints which hold a value.  The content in the lookup tables dosen't change often, hence refered as lookup (reference).

Example : Countries table

Countries are not added on regular bases hence one can consider the table as a lookup table.  As and when needed in some other table the countries information can be fetched base on PK - Country-Code column. Eg - Emp_Per_Info.