Countries List in SQL Server

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
ANIL SINGH

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..
My Blogs - https://code-sample.com and https://code-sample.xyz
My Book1 - BEST SELLING ANGULAR BOOK (INCLUDING ALL VERSIONS 2, 4, 5, 6, 7)
My Book2 - ANGULAR 2 INTERVIEW QUESTIONS BOOK - Both Books are Available on WorldWide.

www.code-sample.com/. Powered by Blogger.
^