Created
October 15, 2014 12:23
-
-
Save potatoqualitee/40e9e485ebeb97374e62 to your computer and use it in GitHub Desktop.
SQL Server ISO 3166
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE countries ( | |
code char(2) PRIMARY KEY NOT NULL, | |
name_en nvarchar(255), | |
name_fr nvarchar(255), | |
) | |
INSERT INTO countries VALUES ('AD','Andorra','Andorre'),('AE','United Arab Emirates','Émirats arabes unis'),('AF','Afghanistan','Afghanistan'),('AG','Antigua and Barbuda','Antigua-et-Barbuda'),('AI','Anguilla','Anguilla'),('AL','Albania','Albanie'),('AM','Armenia','Arménie'),('AO','Angola','Angola'),('AQ','Antarctica','Antarctique'),('AR','Argentina','Argentine'),('AS','American Samoa','Samoa américaine'),('AT','Austria','Autriche'),('AU','Australia','Australie'),('AW','Aruba','Aruba'),('AX','Åland Islands','Îles d''Åland'),('AZ','Azerbaijan','Azerbaïdjan'),('BA','Bosnia and Herzegovina','Bosnie-Herzégovine'),('BB','Barbados','Barbade'),('BD','Bangladesh','Bangladesh'),('BE','Belgium','Belgique'),('BF','Burkina Faso','Burkina Faso'),('BG','Bulgaria','Bulgarie'),('BH','Bahrain','Bahreïn'),('BI','Burundi','Burundi'),('BJ','Benin','Bénin'),('BL','Saint Barthélemy','Saint-Barthélemy'),('BM','Bermuda','Bermudes'),('BN','Brunei Darussalam','Brunei Darussalam'),('BO','Bolivia','Bolivie'),('BQ','Caribbean Netherlands ','Pays-Bas caribéens'),('BR','Brazil','Brésil'),('BS','Bahamas','Bahamas'),('BT','Bhutan','Bhoutan'),('BV','Bouvet Island','Île Bouvet'),('BW','Botswana','Botswana'),('BY','Belarus','Bélarus'),('BZ','Belize','Belize'),('CA','Canada','Canada'),('CC','Cocos (Keeling) Islands','Îles Cocos (Keeling)'),('CD','Congo, Democratic Republic of','Congo, République démocratique du'),('CF','Central African Republic','République centrafricaine'),('CG','Congo','Congo'),('CH','Switzerland','Suisse'),('CI','Côte d''Ivoire','Côte d''Ivoire'),('CK','Cook Islands','Îles Cook'),('CL','Chile','Chili'),('CM','Cameroon','Cameroun'),('CN','China','Chine'),('CO','Colombia','Colombie'),('CR','Costa Rica','Costa Rica'),('CU','Cuba','Cuba'),('CV','Cape Verde','Cap-Vert'),('CW','Curaçao','Curaçao'),('CX','Christmas Island','Île Christmas'),('CY','Cyprus','Chypre'),('CZ','Czech Republic','République tchèque'),('DE','Germany','Allemagne'),('DJ','Djibouti','Djibouti'),('DK','Denmark','Danemark'),('DM','Dominica','Dominique'),('DO','Dominican Republic','République dominicaine'),('DZ','Algeria','Algérie'),('EC','Ecuador','Équateur'),('EE','Estonia','Estonie'),('EG','Egypt','Égypte'),('EH','Western Sahara','Sahara Occidental'),('ER','Eritrea','Érythrée'),('ES','Spain','Espagne'),('ET','Ethiopia','Éthiopie'),('FI','Finland','Finlande'),('FJ','Fiji','Fidji'),('FK','Falkland Islands','Îles Malouines'),('FM','Micronesia, Federated States of','Micronésie, États fédérés de'),('FO','Faroe Islands','Îles Féroé'),('FR','France','France'),('GA','Gabon','Gabon'),('GB','United Kingdom','Royaume-Uni'),('GD','Grenada','Grenade'),('GE','Georgia','Géorgie'),('GF','French Guiana','Guyane française'),('GG','Guernsey','Guernesey'),('GH','Ghana','Ghana'),('GI','Gibraltar','Gibraltar'),('GL','Greenland','Groenland'),('GM','Gambia','Gambie'),('GN','Guinea','Guinée'),('GP','Guadeloupe','Guadeloupe'),('GQ','Equatorial Guinea','Guinée équatoriale'),('GR','Greece','Grèce'),('GS','South Georgia and the South Sandwich Islands','Géorgie du Sud et les îles Sandwich du Sud'),('GT','Guatemala','Guatemala'),('GU','Guam','Guam'),('GW','Guinea-Bissau','Guinée-Bissau'),('GY','Guyana','Guyana'),('HK','Hong Kong','Hong Kong'),('HM','Heard and McDonald Islands','Îles Heard et McDonald'),('HN','Honduras','Honduras'),('HR','Croatia','Croatie'),('HT','Haiti','Haïti'),('HU','Hungary','Hongrie'),('ID','Indonesia','Indonésie'),('IE','Ireland','Irlande'),('IL','Israel','Israël'),('IM','Isle of Man','Île de Man'),('IN','India','Inde'),('IO','British Indian Ocean Territory','Territoire britannique de l''océan Indien'),('IQ','Iraq','Irak'),('IR','Iran','Iran'),('IS','Iceland','Islande'),('IT','Italy','Italie'),('JE','Jersey','Jersey'),('JM','Jamaica','Jamaïque'),('JO','Jordan','Jordanie'),('JP','Japan','Japon'),('KE','Kenya','Kenya'),('KG','Kyrgyzstan','Kirghizistan'),('KH','Cambodia','Cambodge'),('KI','Kiribati','Kiribati'),('KM','Comoros','Comores'),('KN','Saint Kitts and Nevis','Saint-Kitts-et-Nevis'),('KP','North Korea','Corée du Nord'),('KR','South Korea','Corée du Sud'),('KW','Kuwait','Koweït'),('KY','Cayman Islands','Îles Caïmans'),('KZ','Kazakhstan','Kazakhstan'),('LA','Lao People''s Democratic Republic','Laos'),('LB','Lebanon','Liban'),('LC','Saint Lucia','Sainte-Lucie'),('LI','Liechtenstein','Liechtenstein'),('LK','Sri Lanka','Sri Lanka'),('LR','Liberia','Libéria'),('LS','Lesotho','Lesotho'),('LT','Lithuania','Lituanie'),('LU','Luxembourg','Luxembourg'),('LV','Latvia','Lettonie'),('LY','Libya','Libye'),('MA','Morocco','Maroc'),('MC','Monaco','Monaco'),('MD','Moldova','Moldavie'),('ME','Montenegro','Monténégro'),('MF','Saint-Martin (France)','Saint-Martin (France)'),('MG','Madagascar','Madagascar'),('MH','Marshall Islands','Îles Marshall'),('MK','Macedonia','Macédoine'),('ML','Mali','Mali'),('MM','Myanmar','Myanmar'),('MN','Mongolia','Mongolie'),('MO','Macau','Macao'),('MP','Northern Mariana Islands','Mariannes du Nord'),('MQ','Martinique','Martinique'),('MR','Mauritania','Mauritanie'),('MS','Montserrat','Montserrat'),('MT','Malta','Malte'),('MU','Mauritius','Maurice'),('MV','Maldives','Maldives'),('MW','Malawi','Malawi'),('MX','Mexico','Mexique'),('MY','Malaysia','Malaisie'),('MZ','Mozambique','Mozambique'),('NA','Namibia','Namibie'),('NC','New Caledonia','Nouvelle-Calédonie'),('NE','Niger','Niger'),('NF','Norfolk Island','Île Norfolk'),('NG','Nigeria','Nigeria'),('NI','Nicaragua','Nicaragua'),('NL','The Netherlands','Pays-Bas'),('NO','Norway','Norvège'),('NP','Nepal','Népal'),('NR','Nauru','Nauru'),('NU','Niue','Niue'),('NZ','New Zealand','Nouvelle-Zélande'),('OM','Oman','Oman'),('PA','Panama','Panama'),('PE','Peru','Pérou'),('PF','French Polynesia','Polynésie française'),('PG','Papua New Guinea','Papouasie-Nouvelle-Guinée'),('PH','Philippines','Philippines'),('PK','Pakistan','Pakistan'),('PL','Poland','Pologne'),('PM','St. Pierre and Miquelon','Saint-Pierre-et-Miquelon'),('PN','Pitcairn','Pitcairn'),('PR','Puerto Rico','Puerto Rico'),('PS','Palestine, State of','Palestine'),('PT','Portugal','Portugal'),('PW','Palau','Palau'),('PY','Paraguay','Paraguay'),('QA','Qatar','Qatar'),('RE','Réunion','Réunion'),('RO','Romania','Roumanie'),('RS','Serbia','Serbie'),('RU','Russian Federation','Russie'),('RW','Rwanda','Rwanda'),('SA','Saudi Arabia','Arabie saoudite'),('SB','Solomon Islands','Îles Salomon'),('SC','Seychelles','Seychelles'),('SD','Sudan','Soudan'),('SE','Sweden','Suède'),('SG','Singapore','Singapour'),('SH','Saint Helena','Sainte-Hélène'),('SI','Slovenia','Slovénie'),('SJ','Svalbard and Jan Mayen Islands','Svalbard et île de Jan Mayen'),('SK','Slovakia','Slovaquie'),('SL','Sierra Leone','Sierra Leone'),('SM','San Marino','Saint-Marin'),('SN','Senegal','Sénégal'),('SO','Somalia','Somalie'),('SR','Suriname','Suriname'),('SS','South Sudan','Soudan du Sud'),('ST','Sao Tome and Principe','Sao Tomé-et-Principe'),('SV','El Salvador','El Salvador'),('SX','Sint Maarten (Dutch part)','Saint-Martin (Pays-Bas)'),('SY','Syria','Syrie'),('SZ','Swaziland','Swaziland'),('TC','Turks and Caicos Islands','Îles Turks et Caicos'),('TD','Chad','Tchad'),('TF','French Southern Territories','Terres australes françaises'),('TG','Togo','Togo'),('TH','Thailand','Thaïlande'),('TJ','Tajikistan','Tadjikistan'),('TK','Tokelau','Tokelau'),('TL','Timor-Leste','Timor-Leste'),('TM','Turkmenistan','Turkménistan'),('TN','Tunisia','Tunisie'),('TO','Tonga','Tonga'),('TR','Turkey','Turquie'),('TT','Trinidad and Tobago','Trinité-et-Tobago'),('TV','Tuvalu','Tuvalu'),('TW','Taiwan','Taïwan'),('TZ','Tanzania','Tanzanie'),('UA','Ukraine','Ukraine'),('UG','Uganda','Ouganda'),('UM','United States Minor Outlying Islands','Îles mineures éloignées des États-Unis'),('US','United States','États-Unis'),('UY','Uruguay','Uruguay'),('UZ','Uzbekistan','Ouzbékistan'),('VA','Vatican','Vatican'),('VC','Saint Vincent and the Grenadines','Saint-Vincent-et-les-Grenadines'),('VE','Venezuela','Venezuela'),('VG','Virgin Islands (British)','Îles Vierges britanniques'),('VI','Virgin Islands (U.S.)','Îles Vierges américaines'),('VN','Vietnam','Vietnam'),('VU','Vanuatu','Vanuatu'),('WF','Wallis and Futuna Islands','Îles Wallis-et-Futuna'),('WS','Samoa','Samoa'),('YE','Yemen','Yémen'),('YT','Mayotte','Mayotte'),('ZA','South Africa','Afrique du Sud'),('ZM','Zambia','Zambie'),('ZW','Zimbabwe','Zimbabwe'); | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment