Assigning extra information to all database table fields
I'm an experienced desktop app programmer, but fairly new to database programming. I'm working with C#/SQL right now. I understand the concept of a lookup table, as in storing a two-character state (such as CA) in a field in one table, and then being able to get the full state name (such as California) from a second table:
AddressID int <PK>
StateCode char(2) <FK>
StateCode char(2) <PK>
My question: is there some similar way to be able to provide just about every field of every table with a means of holding common, extra information? For instance, let's say I wanted to store, say, an extended name and some special code with every field in three tables. As in this simplistic example:
If I wanted to be able to have the information in the ExtraInfo table associated with each field in Table A, Table B and Table C, how would I do that?
Sticking with what you started with above and applying it to the question - do you mean store the StateCode in several tables? If so then yes and very easily. If not, are you thinking of a One True Lookup Table? http://www.dbforums.com/showthread.php?t=1614898