Creating a table of countries.

Feb 27, 2013 | Scripting and programming, Server administration, Technology, Windows | 0 comments

This is actually really easy but now that i’ve done it, I thought you might want a copy. So. Here goes. Just create your countries table, create a row for id and name, modify the below script to match your details and away you go.
This script to generate a countries table is written for SQL 2008.

USE [YourDatabaseName]
GO

INSERT INTO [dbo].[countriesTable]
([CountryName])

VALUES
(‘Afghanistan’),
(‘Albania’),
(‘Algeria’),
(‘American Samoa’),
(‘Andorra’),
(‘Angola’),
(‘Anguilla’),
(‘Antarctica’),
(‘Antigua and Barbuda’),
(‘Argentina’),
(‘Armenia’),
(‘Armenia’),
(‘Aruba’),
(‘Australia’),
(‘Austria’),
(‘Azerbaijan’),
(‘Azerbaijan’),
(‘Bahamas’),
(‘Bahrain’),
(‘Bangladesh’),
(‘Barbados’),
(‘Belarus’),
(‘Belgium’),
(‘Belize’),
(‘Benin’),
(‘Bermuda’),
(‘Bhutan’),
(‘Bolivia’),
(‘Bosnia and Herzegovina’),
(‘Botswana’),
(‘Bouvet Island’),
(‘Brazil’),
(‘British Indian Ocean Territory’),
(‘Brunei Darussalam’),
(‘Bulgaria’),
(‘Burkina Faso’),
(‘Burundi’),
(‘Cambodia’),
(‘Cameroon’),
(‘Canada’),
(‘Cape Verde’),
(‘Cayman Islands’),
(‘Central African Republic’),
(‘Chad’),
(‘Chile’),
(‘China’),
(‘Christmas Island’),
(‘Cocos KeelingIslands’),
(‘Colombia’),
(‘Comoros’),
(‘Congo’),
(‘Cook Islands’),
(‘Costa Rica’),
(‘Croatia’),
(‘Cuba’),
(‘Cyprus’),
(‘Czech Republic’),
(‘Denmark’),
(‘Djibouti’),
(‘Dominica’),
(‘Dominican Republic’),
(‘Easter Island’),
(‘Ecuador’),
(‘Egypt’),
(‘El Salvador’),
(‘Equatorial Guinea’),
(‘Eritrea’),
(‘Estonia’),
(‘Ethiopia’),
(‘Falkland Islands Malvinas,’),
(‘Faroe Islands’),
(‘Fiji’),
(‘Finland’),
(‘France’),
(‘French Guiana’),
(‘French Polynesia’),
(‘French Southern Territories’),
(‘Gabon’),
(‘Gambia’),
(‘Georgia’),
(‘Germany’),
(‘Ghana’),
(‘Gibraltar’),
(‘Greece’),
(‘Greenland’),
(‘Grenada’),
(‘Guadeloupe’),
(‘Guam’),
(‘Guatemala’),
(‘Guinea’),
(‘Guinea-bissau’),
(‘Guyana’),
(‘Haiti’),
(‘Heard Island and Mcdonald Islands’),
(‘Honduras’),
(‘Hong Kong’),
(‘Hungary’),
(‘Iceland’),
(‘India’),
(‘Indonesia’),
(‘Indonesia’),
(‘Iran’),
(‘Iraq’),
(‘Ireland’),
(‘Israel’),
(‘Italy’),
(‘Jamaica’),
(‘Japan’),
(‘Jordan’),
(‘Kazakhstan’),
(‘Kazakhstan’),
(‘Kenya’),
(‘Kiribati’),
(‘Korea’),
(‘Kosovo’),
(‘Kuwait’),
(‘Kyrgyzstan’),
(‘Laos’),
(‘Latvia’),
(‘Lebanon’),
(‘Lesotho’),
(‘Liberia’),
(‘Libyan Arab Jamahiriya’),
(‘Liechtenstein’),
(‘Lithuania’),
(‘Luxembourg’),
(‘Macau’),
(‘Macedonia’),
(‘Madagascar’),
(‘Malawi’),
(‘Malaysia’),
(‘Maldives’),
(‘Mali’),
(‘Malta’),
(‘Marshall Islands’),
(‘Martinique’),
(‘Mauritania’),
(‘Mauritius’),
(‘Mayotte’),
(‘Mexico’),
(‘Micronesia’),
(‘Moldova’),
(‘Monaco’),
(‘Mongolia’),
(‘Montenegro’),
(‘Montserrat’),
(‘Morocco’),
(‘Mozambique’),
(‘Myanmar’),
(‘Namibia’),
(‘Nauru’),
(‘Nepal’),
(‘Netherlands’),
(‘Netherlands Antilles’),
(‘New Caledonia’),
(‘New Zealand’),
(‘Nicaragua’),
(‘Niger’),
(‘Nigeria’),
(‘Niue’),
(‘Norfolk Island’),
(‘Northern Mariana Islands’),
(‘Norway’),
(‘Oman’),
(‘Pakistan’),
(‘Palau’),
(‘Palestinian Territory’),
(‘Panama’),
(‘Papua New Guinea’),
(‘Paraguay’),
(‘Peru’),
(‘Philippines’),
(‘Pitcairn’),
(‘Poland’),
(‘Portugal’),
(‘Puerto Rico’),
(‘Qatar’),
(‘Reunion’),
(‘Romania’),
(‘Russia’),
(‘Rwanda’),
(‘Saint Helena’),
(‘Saint Kitts and Nevis’),
(‘Saint Lucia’),
(‘Saint Pierre and Miquelon’),
(‘Saint Vincent and The Grenadines’),
(‘Samoa’),
(‘San Marino’),
(‘Sao Tome and Principe’),
(‘Saudi Arabia’),
(‘Senegal’),
(‘Serbia and Montenegro’),
(‘Seychelles’),
(‘Sierra Leone’),
(‘Singapore’),
(‘Slovakia’),
(‘Slovenia’),
(‘Solomon Islands’),
(‘Somalia’),
(‘South Africa’),
(‘South Georgia and The South Sandwich Islands’),
(‘Spain’),
(‘Sri Lanka’),
(‘Sudan’),
(‘Suriname’),
(‘Svalbard and Jan Mayen’),
(‘Swaziland’),
(‘Sweden’),
(‘Switzerland’),
(‘Syria’),
(‘Taiwan’),
(‘Tajikistan’),
(‘Tanzania’),
(‘Thailand’),
(‘Timor-leste’),
(‘Togo’),
(‘Tokelau’),
(‘Tonga’),
(‘Trinidad and Tobago’),
(‘Tunisia’),
(‘Turkey’),
(‘Turkey’),
(‘Turkmenistan’),
(‘Turks and Caicos Islands’),
(‘Tuvalu’),
(‘Uganda’),
(‘Ukraine’),
(‘United Arab Emirates’),
(‘United Kingdom’),
(‘United States’),
(‘United States Minor Outlying Islands’),
(‘Uruguay’),
(‘Uzbekistan’),
(‘Vanuatu’),
(‘Vatican City’),
(‘Venezuela’),
(‘Vietnam’),
(‘Virgin Islands’),
(‘Wallis and Futuna’),
(‘Western Sahara’),
(‘Yemen’),
(‘Zambia’),
(‘Zimbabwe’)
GO

One quick note: when creating your table, I suggest that you make the ID column an integer and under identity you set it to increment. That way, you won’t need to worry about generating ID’s while adding the countries. Why bother!

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.