Tuesday 10 April 2018

Download list of Countries in format ISO 3166-1 alpha-3 and Sql and CSV file



Entire universes Country Code in three letter sets arrange according to ISO 3166-1 is given on Wikipedia.

Be that as it may, there is heaps of manual work for making them accessible for utilizing as a part of web application database.

I have appended prepared to use for Microsoft SQL server at the base of the post and with minor adjustment, it can be utilized for MySql database too.

You may also like:
What is The Best CMS for Startups or Small Business?
How You can Improve Website's Search Results on Google Without SEO Experts?

http://en.wikipedia.org/wiki/ISO_3166-1_alpha-3

Here is the full Code:

/****** Object:  Table [dbo].[CountryCodeISO] Script Date: 13-May-14 3:49:07 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CountryCodeISO](
   [Code] [varchar](50) NULL,
   [Name] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'ABW', N'Aruba')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'AFG', N'Afghanistan')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'AGO', N'Angola')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'AIA', N'Anguilla')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'ALA', N'Åland Islands')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'ALB', N'Albania')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'AND', N'Andorra')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'ARE', N'United Arab Emirates')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'ARG', N'Argentina')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'ARM', N'Armenia')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'ASM', N'American Samoa')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'ATA', N'Antarctica')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'ATF', N'French Southern Territories')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'ATG', N'Antigua and Barbuda')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'AUS', N'Australia')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'AUT', N'Austria')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'AZE', N'Azerbaijan')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'BDI', N'Burundi')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'BEL', N'Belgium')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'BEN', N'Benin')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'BES', N'Bonaire, Sint Eustatius and Saba')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'BFA', N'Burkina Faso')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'BGD', N'Bangladesh')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'BGR', N'Bulgaria')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'BHR', N'Bahrain')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'BHS', N'Bahamas')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'BIH', N'Bosnia and Herzegovina')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'BLM', N'Saint Barthélemy')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'BLR', N'Belarus')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'BLZ', N'Belize')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'BMU', N'Bermuda')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'BOL', N'Bolivia, Plurinational State of')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'BRA', N'Brazil')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'BRB', N'Barbados')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'BRN', N'Brunei Darussalam')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'BTN', N'Bhutan')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'BVT', N'Bouvet Island')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'BWA', N'Botswana')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'CAF', N'Central African Republic')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'CAN', N'Canada')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'CCK', N'Cocos (Keeling) Islands')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'CHE', N'Switzerland')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'CHL', N'Chile')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'CHN', N'China')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'CIV', N'Côte d''Ivoire')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'CMR', N'Cameroon')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'COD', N'Congo, the Democratic Republic of the')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'COG', N'Congo')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'COK', N'Cook Islands')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'COL', N'Colombia')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'COM', N'Comoros')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'CPV', N'Cape Verde')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'CRI', N'Costa Rica')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'CUB', N'Cuba')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'CUW', N'Curaçao')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'CXR', N'Christmas Island')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'CYM', N'Cayman Islands')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'CYP', N'Cyprus')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'CZE', N'Czech Republic')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'DEU', N'Germany')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'DJI', N'Djibouti')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'DMA', N'Dominica')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'DNK', N'Denmark')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'DOM', N'Dominican Republic')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'DZA', N'Algeria')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'ECU', N'Ecuador')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'EGY', N'Egypt')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'ERI', N'Eritrea')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'ESH', N'Western Sahara')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'ESP', N'Spain')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'EST', N'Estonia')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'ETH', N'Ethiopia')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'FIN', N'Finland')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'FJI', N'Fiji')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'FLK', N'Falkland Islands (Malvinas)')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'FRA', N'France')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'FRO', N'Faroe Islands')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'FSM', N'Micronesia, Federated States of')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'GAB', N'Gabon')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'GBR', N'United Kingdom')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'GEO', N'Georgia')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'GGY', N'Guernsey')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'GHA', N'Ghana')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'GIB', N'Gibraltar')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'GIN', N'Guinea')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'GLP', N'Guadeloupe')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'GMB', N'Gambia')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'GNB', N'Guinea-Bissau')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'GNQ', N'Equatorial Guinea')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'GRC', N'Greece')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'GRD', N'Grenada')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'GRL', N'Greenland')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'GTM', N'Guatemala')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'GUF', N'French Guiana')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'GUM', N'Guam')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'GUY', N'Guyana')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'HKG', N'Hong Kong')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'HMD', N'Heard Island and McDonald Islands')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'HND', N'Honduras')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'HRV', N'Croatia')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'HTI', N'Haiti')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'HUN', N'Hungary')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'IDN', N'Indonesia')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'IMN', N'Isle of Man')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'IND', N'India')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'IOT', N'British Indian Ocean Territory')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'IRL', N'Ireland')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'IRN', N'Iran, Islamic Republic of')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'IRQ', N'Iraq')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'ISL', N'Iceland')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'ISR', N'Israel')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'ITA', N'Italy')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'JAM', N'Jamaica')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'JEY', N'Jersey')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'JOR', N'Jordan')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'JPN', N'Japan')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'KAZ', N'Kazakhstan')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'KEN', N'Kenya')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'KGZ', N'Kyrgyzstan')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'KHM', N'Cambodia')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'KIR', N'Kiribati')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'KNA', N'Saint Kitts and Nevis')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'KOR', N'Korea, Republic of')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'KWT', N'Kuwait')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'LAO', N'Lao People''s Democratic Republic')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'LBN', N'Lebanon')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'LBR', N'Liberia')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'LBY', N'Libya')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'LCA', N'Saint Lucia')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'LIE', N'Liechtenstein')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'LKA', N'Sri Lanka')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'LSO', N'Lesotho')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'LTU', N'Lithuania')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'LUX', N'Luxembourg')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'LVA', N'Latvia')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'MAC', N'Macao')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'MAF', N'Saint Martin (French part)')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'MAR', N'Morocco')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'MCO', N'Monaco')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'MDA', N'Moldova, Republic of')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'MDG', N'Madagascar')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'MDV', N'Maldives')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'MEX', N'Mexico')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'MHL', N'Marshall Islands')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'MKD', N'Macedonia, the former Yugoslav Republic of')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'MLI', N'Mali')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'MLT', N'Malta')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'MMR', N'Myanmar')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'MNE', N'Montenegro')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'MNG', N'Mongolia')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'MNP', N'Northern Mariana Islands')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'MOZ', N'Mozambique')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'MRT', N'Mauritania')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'MSR', N'Montserrat')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'MTQ', N'Martinique')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'MUS', N'Mauritius')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'MWI', N'Malawi')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'MYS', N'Malaysia')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'MYT', N'Mayotte')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'NAM', N'Namibia')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'NCL', N'New Caledonia')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'NER', N'Niger')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'NFK', N'Norfolk Island')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'NGA', N'Nigeria')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'NIC', N'Nicaragua')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'NIU', N'Niue')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'NLD', N'Netherlands')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'NOR', N'Norway')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'NPL', N'Nepal')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'NRU', N'Nauru')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'NZL', N'New Zealand')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'OMN', N'Oman')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'PAK', N'Pakistan')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'PAN', N'Panama')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'PCN', N'Pitcairn')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'PER', N'Peru')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'PHL', N'Philippines')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'PLW', N'Palau')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'PNG', N'Papua New Guinea')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'POL', N'Poland')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'PRI', N'Puerto Rico')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'PRK', N'Korea, Democratic People''s Republic of')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'PRT', N'Portugal')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'PRY', N'Paraguay')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'PSE', N'Palestine, State of')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'PYF', N'French Polynesia')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'QAT', N'Qatar')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'REU', N'Réunion')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'ROU', N'Romania')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'RUS', N'Russian Federation')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'RWA', N'Rwanda')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'SAU', N'Saudi Arabia')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'SDN', N'Sudan')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'SEN', N'Senegal')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'SGP', N'Singapore')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'SGS', N'South Georgia and the South Sandwich Islands')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'SHN', N'Saint Helena, Ascension and Tristan da Cunha')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'SJM', N'Svalbard and Jan Mayen')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'SLB', N'Solomon Islands')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'SLE', N'Sierra Leone')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'SLV', N'El Salvador')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'SMR', N'San Marino')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'SOM', N'Somalia')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'SPM', N'Saint Pierre and Miquelon')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'SRB', N'Serbia')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'SSD', N'South Sudan')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'STP', N'Sao Tome and Principe')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'SUR', N'Suriname')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'SVK', N'Slovakia')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'SVN', N'Slovenia')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'SWE', N'Sweden')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'SWZ', N'Swaziland')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'SXM', N'Sint Maarten (Dutch part)')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'SYC', N'Seychelles')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'SYR', N'Syrian Arab Republic')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'TCA', N'Turks and Caicos Islands')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'TCD', N'Chad')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'TGO', N'Togo')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'THA', N'Thailand')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'TJK', N'Tajikistan')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'TKL', N'Tokelau')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'TKM', N'Turkmenistan')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'TLS', N'Timor-Leste')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'TON', N'Tonga')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'TTO', N'Trinidad and Tobago')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'TUN', N'Tunisia')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'TUR', N'Turkey')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'TUV', N'Tuvalu')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'TWN', N'Taiwan, Province of China')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'TZA', N'Tanzania, United Republic of')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'UGA', N'Uganda')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'UKR', N'Ukraine')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'UMI', N'United States Minor Outlying Islands')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'URY', N'Uruguay')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'USA', N'United States')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'UZB', N'Uzbekistan')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'VAT', N'Holy See (Vatican City State)')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'VCT', N'Saint Vincent and the Grenadines')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'VEN', N'Venezuela, Bolivarian Republic of')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'VGB', N'Virgin Islands, British')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'VIR', N'Virgin Islands, U.S.')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'VNM', N'Viet Nam')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'VUT', N'Vanuatu')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'WLF', N'Wallis and Futuna')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'WSM', N'Samoa')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'YEM', N'Yemen')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'ZAF', N'South Africa')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'ZMB', N'Zambia')
GO
INSERT [dbo].[CountryCodeISO] ([Code], [Name]) VALUES (N'ZWE', N'Zimbabwe')
GO
I trust that this ISO_3166-1_alpha-3 will be workable for you folks, you may likewise observe all the more coding methods and traps for throughout the day you are confronting. benevolently take after our blog here.

By at
Labels: , , , , , , , , , , , , , ,
Location: California, USA

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Twilio Programmable Wireless Moves from Beta to General Availability

Twilio has declared that Programmable Wireless is currently out of beta and by and large accessible (GA). Twilio Programmable Wireless ...