Top level domain names and country codes!
Last updated: July 21st '02 | Best viewed with: All popular browsers | Best viewed at: 1024x768 | Links to external sites will open in a new window

See also:   Database coding conventions SQL Server interview questions Evaluation of federated database servers SQL Server FAQ on programming, administration, replication and tools SQL Server security best practices SQL Server administration best practices

Related books:

Top level domain names and country codes!


You could use the following INSERT statements to populate a Country table (table structure available here) with the country code and country name.

INSERT INTO [Countries] ([CountryCode],[Country])VALUES('AD','Andorra')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('AE','United Arab Emirates')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('AF','Afghanistan')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('AG','Antigua and Barbuda')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('AI','Anguilla')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('AL','Albania')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('AM','Armenia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('AN','Netherlands Antilles')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('AO','Angola')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('AQ','Antarctica')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('AR','Argentina')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('AS','American Samoa')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('AT','Austria')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('AU','Australia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('AW','Aruba')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('AZ','Azerbaijan')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('BA','Bosnia and Herzegovina')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('BB','Barbados')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('BD','Bangladesh')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('BE','Belgium')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('BF','Burkina Faso')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('BG','Bulgaria')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('BH','Bahrain')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('BI','Burundi')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('BJ','Benin')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('BM','Bermuda')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('BN','Brunei Darussalam')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('BO','Bolivia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('BR','Brazil')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('BS','Bahamas')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('BT','Bhutan')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('BV','Bouvet Island')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('BW','Botswana')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('BY','Belarus')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('BZ','Belize')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('CA','Canada')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('CC','Cocos (Keeling) Islands')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('CF','Central African Republic')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('CG','Congo')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('CH','Switzerland')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('CI','Cote D''Ivoire (Ivory Coast)')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('CK','Cook Islands')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('CL','Chile')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('CM','Cameroon')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('CN','China')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('CO','Colombia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('CR','Costa Rica')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('CS','Czechoslovakia (former)')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('CU','Cuba')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('CV','Cape Verde')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('CX','Christmas Island')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('CY','Cyprus')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('CZ','Czech Republic')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('DE','Germany')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('DJ','Djibouti')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('DK','Denmark')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('DM','Dominica')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('DO','Dominican Republic')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('DZ','Algeria')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('EC','Ecuador')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('EE','Estonia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('EG','Egypt')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('EH','Western Sahara')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('ER','Eritrea')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('ES','Spain')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('ET','Ethiopia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('FI','Finland')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('FJ','Fiji')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('FK','Falkland Islands (Malvinas)')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('FM','Micronesia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('FO','Faroe Islands')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('FR','France')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('FX','France, Metropolitan')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('GA','Gabon')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('GB','Great Britain (UK)')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('GD','Grenada')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('GE','Georgia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('GF','French Guiana')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('GH','Ghana')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('GI','Gibraltar')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('GL','Greenland')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('GM','Gambia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('GN','Guinea')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('GP','Guadeloupe')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('GQ','Equatorial Guinea')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('GR','Greece')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('GS','S. Georgia and S. Sandwich Isls.')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('GT','Guatemala')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('GU','Guam')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('GW','Guinea-Bissau')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('GY','Guyana')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('HK','Hong Kong')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('HM','Heard and McDonald Islands')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('HN','Honduras')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('HR','Croatia (Hrvatska)')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('HT','Haiti')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('HU','Hungary')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('ID','Indonesia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('IE','Ireland')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('IL','Israel')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('IN','India')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('IO','British Indian Ocean Territory')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('IQ','Iraq')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('IR','Iran')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('IS','Iceland')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('IT','Italy')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('JM','Jamaica')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('JO','Jordan')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('JP','Japan')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('KE','Kenya')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('KG','Kyrgyzstan')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('KH','Cambodia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('KI','Kiribati')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('KM','Comoros')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('KN','Saint Kitts and Nevis')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('KP','Korea (North)')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('KR','Korea (South)')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('KW','Kuwait')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('KY','Cayman Islands')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('KZ','Kazakhstan')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('LA','Laos')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('LB','Lebanon')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('LC','Saint Lucia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('LI','Liechtenstein')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('LK','Sri Lanka')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('LR','Liberia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('LS','Lesotho')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('LT','Lithuania')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('LU','Luxembourg')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('LV','Latvia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('LY','Libya')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('MA','Morocco')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('MC','Monaco')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('MD','Moldova')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('MG','Madagascar')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('MH','Marshall Islands')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('MK','Macedonia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('ML','Mali')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('MM','Myanmar')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('MN','Mongolia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('MO','Macau')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('MP','Northern Mariana Islands')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('MQ','Martinique')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('MR','Mauritania')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('MS','Montserrat')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('MT','Malta')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('MU','Mauritius')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('MV','Maldives')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('MW','Malawi')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('MX','Mexico')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('MY','Malaysia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('MZ','Mozambique')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('NA','Namibia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('NC','New Caledonia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('NE','Niger')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('NF','Norfolk Island')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('NG','Nigeria')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('NI','Nicaragua')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('NL','Netherlands')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('NO','Norway')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('NP','Nepal')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('NR','Nauru')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('NT','Neutral Zone')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('NU','Niue')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('NZ','New Zealand (Aotearoa)')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('OM','Oman')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('PA','Panama')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('PE','Peru')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('PF','French Polynesia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('PG','Papua New Guinea')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('PH','Philippines')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('PK','Pakistan')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('PL','Poland')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('PM','St. Pierre and Miquelon')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('PN','Pitcairn')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('PR','Puerto Rico')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('PT','Portugal')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('PW','Palau')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('PY','Paraguay')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('QA','Qatar')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('RE','Reunion')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('RO','Romania')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('RU','Russia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('RW','Rwanda')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('SA','Saudi Arabia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('Sb','Solomon Islands')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('SC','Seychelles')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('SD','Sudan')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('SE','Sweden')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('SG','Singapore')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('SH','St. Helena')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('SI','Slovenia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('SJ','Svalbard and Jan Mayen Islands')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('SK','Slovak Republic')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('SL','Sierra Leone')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('SM','San Marino')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('SN','Senegal')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('SO','Somalia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('SR','Suriname')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('ST','Sao Tome and Principe')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('SU','USSR (former)')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('SV','El Salvador')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('SY','Syria')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('SZ','Swaziland')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('TC','Turks and Caicos Islands')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('TD','Chad')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('TF','French Southern Territories')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('TG','Togo')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('TH','Thailand')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('TJ','Tajikistan')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('TK','Tokelau')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('TM','Turkmenistan')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('TN','Tunisia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('TO','Tonga')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('TP','East Timor')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('TR','Turkey')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('TT','Trinidad and Tobago')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('TV','Tuvalu')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('TW','Taiwan')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('TZ','Tanzania')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('UA','Ukraine')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('UG','Uganda')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('UK','United Kingdom')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('UM','US Minor Outlying Islands')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('US','United States')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('UY','Uruguay')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('UZ','Uzbekistan')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('VA','Vatican City State (Holy See)')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('VC','Saint Vincent and the Grenadines')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('VE','Venezuela')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('VG','Virgin Islands (British)')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('VI','Virgin Islands (U.S.)')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('VN','Viet Nam')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('VU','Vanuatu')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('WF','Wallis and Futuna Islands')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('WS','Samoa')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('YE','Yemen')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('YT','Mayotte')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('YU','Yugoslavia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('ZA','South Africa')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('ZM','Zambia')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('ZR','Zaire')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('ZW','Zimbabwe')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('COM','US Commercial')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('EDU','US Educational')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('GOV','US Government')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('INT','International')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('MIL','US Military')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('NET','Network')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('ORG','Non-Profit Organization')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('ARPA','Arpanet')
INSERT INTO [Countries] ([CountryCode],[Country])VALUES('NATO','Nato field')