Lookup tables provide key/value pairs for data in databases as a part of normalization and standardization of data. A basic example would be a States table or Countries table that contains the valid values for States and Countries that can be used
by the application. See this article on SQL Server Central for some further information:
Jonathan Kehayias | Senior Consultant,
SQLSkills.com SQL Server MVP | Microsoft Certified Master: SQL Server 2008
Feel free to contact me through
My Blog or
Please click the Mark as Answer button if a post solves your problem!