List of Nationality, Countries and Code in SQL Server

Download JSON file - Click on JSON file

      AND

Download JSON file - Click on Excel file

--NATIONALITY TABLE

CREATE TABLE [dbo].[Nationality]

(

            [NationalityID] [int] IDENTITY(1,1) NOT NULL,

            [Country] [nvarchar](55) NULL,

            [CountryCode] [nvarchar](4) NULL,

            [Nationality] [nvarchar] (140) NULL,

            [Person] [nvarchar] (120) NULL

) ON [PRIMARY]

GO

--INSERT NATIONALITY TABLE

INSERT INTO [dbo].[Nationality](Country, CountryCode, Nationality, Person )

VALUES 

        ( 'UNITED KINGDOM','GB','British','a Briton' ),

        ( 'ARGENTINA','AR','Argentinian','an Argentinian' ),

        ( 'AUSTRALIA','AU','Australian','an Australian' ),

        ( 'BAHAMAS','BS','Bahamian','a Bahamian' ),

        ( 'BELGIUM','BE','Belgian','a Belgian' ),

        ( 'BRAZIL','BR','Brazilian','a Brazilian' ),

        ( 'CANADA','CA','Canadian','a Canadian' ),

        ( 'CHINA','CN','Chinese','a Chinese' ),

        ( 'COLOMBIA','CO','Colombian','a Colombian' ),

        ( 'CUBA','CU','Cuban','a Cuban' ),

        ( 'DOMINICAN REPUBLIC','DO','Dominican','a Dominican' ),

        ( 'ECUADOR','EC','Ecuadorean','an Ecuadorean' ),

        ( 'EL SALVADOR','SV','Salvadorean','a Salvadorean' ),

        ( 'FRANCE','FR','French','a Frenchman, a Frenchwoman' ),

        ( 'GERMANY','DE','German','a German' ),

        ( 'GUATEMALA','GT','Guatemalan','a Guatemalan' ),

        ( 'HAITI','HT','Haitian','a Haitian' ),

        ( 'HONDURAS','HN','Honduran','a Honduran' ),

        ( 'INDIA','IN','Indian','an Indian' ),

        ( 'IRELAND','IE','Ireland','an Irishman, an Irishwoman' ),

        ( 'ISRAEL','IL','Israeli','an Israeli' ),

        ( 'ITALY','IT','Italian','an Italian' ),

        ( 'JAPAN','JP','Japanese','a Japanese' ),

        ( 'KOREA - REPUBLIC OF','KR','South Korean','a South Korean' ),

        ( 'MEXICO','MX','Mexican','a Mexican' ),

        ( 'NETHERLANDS','NL','Dutch','a Dutchman, a Dutchwoman' ),

        ( 'PHILIPPINES','PH','Philippine','a Filipino' ),

        ( 'SPAIN','ES','Spanish','a Spaniard' ),

        ( 'SWEDEN','SE','Swedish','a Swede' ),

        ( 'SWITZERLAND','CH','Swiss','a Swiss' ),

        ( 'TAIWAN - PROVINCE OF CHINA','TW','Taiwanese','a Taiwanese' ),

        ( 'VENEZUELA - BOLIVARIAN REPUBLIC OF','VE','Venezuelan','a Venezuelan' ),

        ( 'VIET NAM','VN','Vietnamese','a Vietnamese' ),

        ( 'AFGHANISTAN','AF','Afghan','an Afghan' ),

        ( 'ALBANIA','AL','Albanian','an Albanian' ),

        ( 'ALGERIA','DZ','Algerian','an Algerian' ),

        ( 'AMERICAN SAMOA','AS','Samoan','a Samoan' ),

        ( 'ANDORRA','AD','Andorran','an Andorran' ),

        ( 'ANGOLA','AO','Angolan','an Angolan' ),

        ( 'ARMENIA','AM','Armenian','an Armenian' ),

        ( 'AUSTRIA','AT','Austrian','an Austrian' ),

        ( 'AZERBAIJAN','AZ','Azerbaijani','an Azerbaijani' ),

        ( 'BAHRAIN','BH','Bahraini','a Bahraini' ),

        ( 'BANGLADESH','BD','Bangladeshi','a Bangladeshi' ),

        ( 'BARBADOS','BB','Barbadian','a Barbadian' ),

        ( 'BELARUS','BY','Belarusian or Belarusan','a Belarusian' ),

        ( 'BELIZE','BZ','Belizean','a Belizean' ),

        ( 'BENIN','BJ','Beninese','a Beninese' ),

        ( 'BERMUDA','BM','Bermudian','a Bermudian' ),

        ( 'BHUTAN','BT','Bhutanese','a Bhutanese' ),

        ( 'BOLIVIA - PLURINATIONAL STATE OF','BO','Bolivian','a Bolivian' ),

        ( 'BOSNIA AND HERZEGOVINA','BA','Bosnian','a Bosnian' ),

        ( 'BOTSWANA','BW','Botswanan','a Tswana' ),

        ( 'BULGARIA','BG','Bulgarian','a Bulgarian' ),

        ( 'BURKINA FASO','BF','Burkinese','a Burkinese' ),

        ( 'BURUNDI','BI','Burundian','a Burundian' ),

        ( 'CAMBODIA','KH','Cambodian','a Cambodian' ),

        ( 'CAMEROON','CM','Cameroonian','a Cameroonian' ),

        ( 'CAPE VERDE ISLANDS','CV','Cape Verdean','a Cape Verdean' ),

        ( 'CHAD','TD','Chadian','a Chadian' ),

        ( 'CHILE','CL','Chilean','a Chilean' ),

        ( 'CONGO','CG','Congolese','a Congolese' ),

        ( 'COSTA RICA','CR','Costa Rican','a Costa Rican' ),

        ( 'CROATIA','HR','Croat or Croatian','a Croat' ),

        ( 'CYPRUS','CY','Cypriot','a Cypriot' ),

        ( 'CZECH REPUBLIC','CZ','Czech','a Czech' ),

        ( 'DENMARK','DK','Danish','a Dane' ),

        ( 'DJIBOUTI','DJ','Djiboutian','a Djiboutian' ),

        ( 'DOMINICA','DM','Dominican','a Dominican' ),

        ( 'EGYPT','EG','Egyptian','an Egyptian' ),

        ( 'ERITREA','ER','Eritrean','an Eritrean' ),

        ( 'ESTONIA','EE','Estonian','an Estonian' ),

        ( 'ETHIOPIA','ET','Ethiopian','an Ethiopian' ),

        ( 'FIJI','FJ','Fijian','a Fijian' ),

        ( 'FINLAND','FI','Finnish','a Finn' ),

        ( 'FRENCH POLYNESIA','PF','French Polynesian','a French Polynesian' ),

        ( 'GABON','GA','Gabonese','a Gabonese' ),

        ( 'GAMBIA','GM','Gambian','a Gambian' ),

        ( 'GEORGIA','GE','Georgian','a Georgian' ),

        ( 'GHANA','GH','Ghanaian','a Ghanaian' ),

        ( 'GREECE','GR','Greek','a Greek' ),

        ( 'GRENADA','GD','Grenadian','a Grenadian' ),

        ( 'GUINEA','GN','Guinean','a Guinean' ),

        ( 'GUYANA','GY','Guyanese','a Guyanese' ),

        ( 'HUNGARY','HU','Hungarian','a Hungarian' ),

        ( 'ICELAND','IS','Icelandic','an Icelander' ),

        ( 'INDONESIA','ID','Indonesian','an Indonesian' ),

        ( 'IRAN - ISLAMIC REPUBLIC OF','IR','Iranian','an Iranian' ),

        ( 'IRAQ','IQ','Iraqi','an Iraqi' ),

        ( 'JAMAICA','JM','Jamaican','a Jamaican' ),

        ( 'JORDAN','JO','Jordanian','a Jordanian' ),

        ( 'KAZAKHSTAN','KZ','Kazakh','a Kazakh' ),

        ( 'KENYA','KE','Kenyan','a Kenyan' ),

        ( 'KOREA - DEMOCRATIC PEOPLE''S REPUBLIC OF','KP','North Korean','a North Korean' ),

        ( 'KUWAIT','KW','Kuwaiti','a Kuwaiti' ),

        ( 'LATVIA','LV','Latvian','a Latvian' ),

        ( 'LEBANON','LB','Lebanese','a Lebanese' ),

        ( 'LIBERIA','LR','Liberian','a Liberian' ),

        ( 'LIBYA','LY','Libyan','a Libyan' ),

        ( 'LITHUANIA','LT','Lithuanian','a Lithuanian' ),

        ( 'LUXEMBOURG','LU','-','a Luxembourger' ),

        ( 'MADAGASCAR','MG','Malagasy or Madagascan','a Malagasy' ),

        ( 'MALAWI','MW','Malawian','a Malawian' ),

        ( 'MALAYSIA','MY','Malaysian','a Malaysian' ),

        ( 'MALDIVES','MV','Maldivian','a Maldivian' ),

        ( 'MALI','ML','Malian','a Malian' ),

        ( 'MALTA','MT','Maltese','a Maltese' ),

        ( 'MAURITANIA','MR','Mauritanian','a Mauritanian' ),

        ( 'MAURITIUS','MU','Mauritian','a Mauritian' ),

        ( 'MONACO','MC','Monégasque or Monacan','a Monégasque or a Monacan' ),

        ( 'MONGOLIA','MN','Mongolian','a Mongolian' ),

        ( 'MONTENEGRO','ME','Montenegrin','a Montenegrin' ),

        ( 'MOROCCO','MA','Moroccan','a Moroccan' ),

        ( 'MOZAMBIQUE','MZ','Mozambican','a Mozambican' ),

        ( 'NAMIBIA','NA','Namibian','a Namibian' ),

        ( 'NEPAL','NP','Nepalese','a Nepalese' ),

        ( 'NICARAGUA','NI','Nicaraguan','a Nicaraguan' ),

        ( 'NIGER','NE','Nigerien','a Nigerien' ),

        ( 'NIGERIA','NG','Nigerian','a Nigerian' ),

        ( 'NORWAY','NO','Norwegian','a Norwegian' ),

        ( 'OMAN','OM','Omani','an Omani' ),

        ( 'PAKISTAN','PK','Pakistani','a Pakistani' ),

        ( 'PANAMA','PA','Panamanian','a Panamanian' ),

        ( 'PARAGUAY','PY','Paraguayan','a Paraguayan' ),

        ( 'PERU','PE','Peruvian','a Peruvian' ),

        ( 'POLAND','PL','Polish','a Pole' ),

        ( 'PORTUGAL','PT','Portuguese','a Portuguese' ),

        ( 'QATAR','QA','Qatari','a Qatari' ),

        ( 'ROMANIA','RO','Romanian','a Romanian' ),

        ( 'RWANDA','RW','Rwandan','a Rwandan' ),

        ( 'SAUDI ARABIA','SA','Saudi Arabian or Saudi','a Saudi Arabian' ),

        ( 'SENEGAL','SN','Senegalese','a Senegalese' ),

        ( 'SERBIA','RS','Serb or Serbian','a Serb or a Serbian' ),

        ( 'SIERRA LEONE','SL','Sierra Leonian','a Sierra Leonian' ),

        ( 'SINGAPORE','SG','Singaporean','a Singaporean' ),

        ( 'SLOVAKIA','SK','Slovak','a Slovak' ),

        ( 'SLOVENIA','SI','Slovene or Slovenian','a Slovene' ),

        ( 'SOLOMON ISLANDS','SB','-','a Solomon Islander' ),

        ( 'SOMALIA','SO','Somali','a Somali' ),

        ( 'SOUTH AFRICA','ZA','South African','a South African' ),

        ( 'SRI LANKA','LK','Sri Lankan','a Sri Lankan' ),

        ( 'SUDAN','SD','Sudanese','a Sudanese' ),

        ( 'SURINAME','SR','Surinamese','a Surinamer' ),

        ( 'SWAZILAND','SZ','Swazi','a Swazi' ),

        ( 'TAJIKISTAN','TJ','Tajik or Tadjik','a Tajik' ),

        ( 'THAILAND','TH','Thai','a Thai' ),

        ( 'TOGO','TG','Togolese','a Togolese' ),

        ( 'TRINIDAD AND TOBAGO','TT','Trinidadian','a Trinidadian' ),

        ( 'TUNISIA','TN','Tunisian','a Tunisian' ),

        ( 'TURKEY','TR','Turkish','a Turk' ),

        ( 'TURKMENISTAN','TM','Turkmen or Turkoman','a Turkmen' ),

        ( 'TUVALU','TV','Tuvaluan','a Tuvaluan' ),

        ( 'UGANDA','UG','Ugandan','a Ugandan' ),

        ( 'UKRAINE','UA','Ukrainian','a Ukrainian' ),

        ( 'UNITED ARAB EMIRATES','AE', 'Emirati', 'a UAE citizen' ),

                        ( 'UNITED STATES','US','American','a US citizen' ),

        ( 'URUGUAY','UY','Uruguayan','a Uruguayan' ),

        ( 'UZBEKISTAN','UZ','Uzbek','an Uzbek' ),

        ( 'VANUATU','VU','Vanuatuan','a Vanuatuan' ),

        ( 'YEMEN','YE','Yemeni','a Yemeni' ),

        ( 'ZAMBIA','ZM','Zambian','a Zambian' )

GO