This post originated from an RSS feed registered with .NET Buzz
by Anand M.
Original Post: Think before Creating that Lookup Table...
Feed Title: .NET From India
Feed URL: http://www.dotnetindia.com/index.rss
Feed Description: Your daily dose of .NET From India
An interesting article at SQLServerCentral on the so called all-in-one Lookup tables.
I agree 100% with the author. I have seen the kind of confusion that one of these table can create. Once people know that there is this thing, every type of code will start getting into it as people like to reuse exisiting facilities, instead of re-inventing the wheel (by creating a new table).
But in real life, I find almost every project lands up with atleast one of these tables.