Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
HockeyFan
Starting Member
26 Posts |
 Posted - 2007-09-05 : 11:16:10
|
| This is an easy one, I hope. Terminology has changed over the years, and I'm not sure what the current nomenclature is with regards to ... I have a table contains State names and State codes. I have another that contains Product names and Product codes. I have another that contains Collateral type names, and Collateral type codes.At one time, I heard these referred to as domain tables, but I don't believe that was a correct label today. We do want to differentiate these tables from other tables that might refer to them. Other tables might be transaction tables, or represent data that will eventually be purged. However, Collateral types are somewhat static in a business environment. So are the names and number of states. Likewise with Countries. Even Products are somewhat static, and certain ProductTypes (or category) might be static.So what is the name that refers to these types of data tables, as opposed to the more transactional data? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-05 : 11:47:32
|
| id's say lookup tables_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-09-06 : 06:44:13
|
| Reference data is another one.Mark |
|
|
|
|
|
|
Terminology question