sql server new users: 1 field or 2? -- sql server new users

Re: 1 field or 2?

Thomas Coleman
6/6/2005 4:03:04 PM

sql server new users: This is a case when I would agree with Mr. Celko in that you should create a
table of Countries and use the ISO country code and start off with the ISO
description of the country. That allows for variations in the name of the
country specific to the company without having to change the entity's to which
the country is assigned. I would further recommend using the three-letter
abbreviations (there is also a set of ISO two letter abbreviations).

Thomas

[quoted text, click to view]

1 field or 2?

toedipper
6/6/2005 11:57:21 PM

Hello,

Imagine I have a table called countries. Every country is the world has a
unique name so should my table just have one field called ie CountryName or
should I have 2 fields including eg Countryid?

I mean, if the countryname fields are unique anyway what is the point of
creating an id field? It just seems to me to create extra baggage.

I'm all new to this so someone point me in the right direction!

Thanks,

td.