Free Download a List of Countries in Format ISO 3166-1 alpha-3 and SQL and CSV file

By: Navin
Updated: September 9th, 2014 | Technology: E-Commerce, Enterprise, nopCommerce, Web Designing

Whole worlds Country Code in three alphabets format as per ISO 3166-1 is given on Wikipedia.

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

But there is lots of manual work for making them available for use in web application database.

I have attached ready to use for Microsoft SQL server at bottom of a post and with minor modification, it can be used for MySql database as well.

Download SQL File

Download CSV file

Preview:

[code lang=”sql”] /****** 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[/code]

I hope that this ISO_3166-1_alpha-3 will be workable for you guys, you may also see more coding techniques and tricks for all day you are facing. kindly follow our blog here.