I was having a hard time to find a database with complete set of country list and its corresponding nationalities... Although I found some but probably they are for sale... and you need to buy it (>.<) ...
So what I've only got (from web surfing / researching) was a text file of country list plus their nationalities. So I don't have any option, so I've created a MS SQL query commands that inserts all 192 countries in a database..by just creating a new script , I mean I coded it into an MS SQL queries that inserts into a table(so you won't need to type it (^.~) ).
Here is the instructions :
1) Download or copy the Query / Scripts I provided.
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Afghanistan', 'Afghan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Albania', 'Albanian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Algeria', 'Algerian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Andorra', 'Andorran')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Angola', 'Angolan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Antigua and Barbuda', 'Antiguans, Barbudans')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Argentina', 'Argentinean')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Armenia', 'Armenian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Australia', 'Australian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Austria', 'Austrian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Azerbaijan', 'Azerbaijani')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('The Bahamas', 'Bahamian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Bahrain', 'Bahraini')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Bangladesh', 'Bangladeshi')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Barbados', 'Barbadian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Belarus', 'Belarusian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Belgium', 'Belgian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Belize', 'Belizean')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Benin', 'Beninese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Bhutan', 'Bhutanese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Bolivia', 'Bolivian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Bosnia and Herzegovina', 'Bosnian, Herzegovinian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Botswana', 'Motswana (singular), Batswana (plural)')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Brazil', 'Brazilian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Brunei', 'Bruneian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Bulgaria', 'Bulgarian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Burkina Faso', 'Burkinabe')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Burundi', 'Burundian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Cambodia', 'Cambodian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Cameroon', 'Cameroonian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Canada', 'Canadian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Cape Verde', 'Cape Verdian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Central African Republic', 'Central African')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Chad', 'Chadian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Chile', 'Chilean')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'China', 'Chinese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Colombia', 'Colombian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Comoros', 'Comoran')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Congo, Republic of the', 'Congolese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Congo, Democratic Republic of the', 'Congolese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Costa Rica', 'Costa Rican')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Cote d”Ivoire', 'Ivorian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Croatia', 'Croatian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Cuba', 'Cuban')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Cyprus', 'Cypriot')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Czech Republic', 'Czech')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Denmark', 'Danish')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Djibouti', 'Djibouti')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Dominica', 'Dominican')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Dominican Republic', 'Dominican')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'East Timor', 'East Timorese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Ecuador', 'Ecuadorean')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Egypt', 'Egyptian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'El Salvador', 'Salvadoran')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Equatorial Guinea', 'Equatorial Guinean')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Eritrea', 'Eritrean')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Estonia', 'Estonian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Ethiopia', 'Ethiopian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Fiji', 'Fijian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Finland', 'Finnish')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'France', 'French')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Gabon', 'Gabonese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'The Gambia', 'Gambian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Georgia', 'Georgian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Germany', 'German')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Ghana', 'Ghanaian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Greece', 'Greek')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Grenada', 'Grenadian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Guatemala', 'Guatemalan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Guinea', 'Guinean')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Guinea-Bissau', 'Guinea-Bissauan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Guyana', 'Guyanese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Haiti', 'Haitian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Honduras', 'Honduran')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Hungary', 'Hungarian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Iceland', 'Icelander')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'India', 'Indian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Indonesia', 'Indonesian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Iran', 'Iranian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Iraq', 'Iraqi')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Ireland', 'Irish')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Israel', 'Israeli')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Italy', 'Italian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Jamaica', 'Jamaican')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Japan', 'Japanese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Jordan', 'Jordanian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Kazakhstan', 'Kazakhstani')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Kenya', 'Kenyan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Kiribati', 'I-Kiribati')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Korea, North', 'North Korean')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Korea, South', 'South Korean')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Kuwait', 'Kuwaiti')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Kyrgyz Republic', 'Kirghiz')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Laos', 'Laotian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Latvia', 'Latvian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Lebanon', 'Lebanese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Lesotho', 'Mosotho')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Liberia', 'Liberian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Libya', 'Libyan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Liechtenstein', 'Liechtensteiner')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Lithuania', 'Lithuanian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Luxembourg', 'Luxembourger')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Macedonia', 'Macedonian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Madagascar', 'Malagasy')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Malawi', 'Malawian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Malaysia', 'Malaysian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Maldives', 'Maldivan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Mali', 'Malian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Malta', 'Maltese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Marshall Islands', 'Marshallese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Mauritania', 'Mauritanian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Mauritius', 'Mauritian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Mexico', 'Mexican')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Federated States of Micronesia', 'Micronesian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Moldova', 'Moldovan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Monaco', 'Monegasque')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Mongolia', 'Mongolian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Morocco', 'Moroccan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Mozambique', 'Mozambican')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Myanmar (Burma)', 'Burmese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Namibia', 'Namibian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Nauru', 'Nauruan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Nepal', 'Nepalese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Netherlands', 'Dutch')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'New Zealand', 'New Zealander')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Nicaragua', 'Nicaraguan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Niger', 'Nigerien')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Nigeria', 'Nigerian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Norway', 'Norwegian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Oman', 'Omani')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Pakistan', 'Pakistani')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Palau', 'Palauan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Panama', 'Panamanian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Papua New Guinea', 'Papua New Guinean')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Paraguay', 'Paraguayan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Peru', 'Peruvian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Philippines', 'Filipino')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Poland', 'Polish')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Portugal', 'Portuguese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Qatar', 'Qatari')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Romania', 'Romanian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Russia', 'Russian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Rwanda', 'Rwandan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Saint Kitts and Nevis', 'Kittian and Nevisian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Saint Lucia', 'Saint Lucian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Samoa', 'Samoan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'San Marino', 'Sammarinese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Sao Tome and Principe', 'Sao Tomean')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Saudi Arabia', 'Saudi Arabian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Senegal', 'Senegalese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Serbia and Montenegro', 'Serbian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Seychelles', 'Seychellois')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Sierra Leone', 'Sierra Leonean')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Singapore', 'Singaporean')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Slovakia', 'Slovak')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Slovenia', 'Slovene')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Solomon Islands', 'Solomon Islander')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Somalia', 'Somali')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'South Africa', 'South African')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Spain', 'Spanish')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Sri Lanka', 'Sri Lankan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Sudan', 'Sudanese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Suriname', 'Surinamer')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Swaziland', 'Swazi')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Sweden', 'Swedish')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Switzerland', 'Swiss')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Syria', 'Syrian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Taiwan', 'Taiwanese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Tajikistan', 'Tadzhik')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Tanzania', 'Tanzanian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Thailand', 'Thai')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Togo', 'Togolese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Tonga', 'Tongan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Trinidad and Tobago', 'Trinidadian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Tunisia', 'Tunisian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Turkey', 'Turkish')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Turkmenistan', 'Turkmen')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Tuvalu', 'Tuvaluan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Uganda', 'Ugandan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Ukraine', 'Ukrainian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'United Arab Emirates', 'Emirian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'United Kingdom', 'British')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values ('United States', 'American')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Uruguay', 'Uruguayan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Uzbekistan', 'Uzbekistani')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Vanuatu', 'Ni-Vanuatu')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Vatican City (Holy See)', 'none')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Venezuela', 'Venezuelan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Vietnam', 'Vietnamese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Yemen', 'Yemeni')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Zambia', 'Zambian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Zimbabwe', 'Zimbabwean')
2) On your MS SQL Enterprise manager(2000 ot later) , then look for your database where you want to place the table for Country
3)Create a table namely "Country"
4) Add the following fields on your table :
* CountryID - You may opt to this as your primary key and make it default value into AUTONUMER or by doing that just make it as Identity Seed = "Yes"
*Name - Country Name
*Nationality - Nationality that corresponds to County
Note : you may add other fields aside from the 3 fields I provided, just be sure to set all fields with default values
5)Save the table and label it with "Country"
6)Go to SQL Query analyzer
7) Open the Script or Copy the Scripts/SQL Commands
8) Paste it at the Query analyzer
9) Finally, Press "F5"
10) Then viola! select your "Country" table , in this way "SELECT * FROM COUNTRY"
I Hope this might help (^_^)!
So what I've only got (from web surfing / researching) was a text file of country list plus their nationalities. So I don't have any option, so I've created a MS SQL query commands that inserts all 192 countries in a database..by just creating a new script , I mean I coded it into an MS SQL queries that inserts into a table(so you won't need to type it (^.~) ).
Here is the instructions :
1) Download or copy the Query / Scripts I provided.
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Afghanistan', 'Afghan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Albania', 'Albanian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Algeria', 'Algerian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Andorra', 'Andorran')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Angola', 'Angolan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Antigua and Barbuda', 'Antiguans, Barbudans')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Argentina', 'Argentinean')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Armenia', 'Armenian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Australia', 'Australian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Austria', 'Austrian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Azerbaijan', 'Azerbaijani')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('The Bahamas', 'Bahamian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Bahrain', 'Bahraini')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Bangladesh', 'Bangladeshi')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Barbados', 'Barbadian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Belarus', 'Belarusian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Belgium', 'Belgian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Belize', 'Belizean')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Benin', 'Beninese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Bhutan', 'Bhutanese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Bolivia', 'Bolivian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Bosnia and Herzegovina', 'Bosnian, Herzegovinian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Botswana', 'Motswana (singular), Batswana (plural)')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Brazil', 'Brazilian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Brunei', 'Bruneian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Bulgaria', 'Bulgarian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Burkina Faso', 'Burkinabe')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Burundi', 'Burundian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Cambodia', 'Cambodian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Cameroon', 'Cameroonian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Canada', 'Canadian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Cape Verde', 'Cape Verdian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Central African Republic', 'Central African')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Chad', 'Chadian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Chile', 'Chilean')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'China', 'Chinese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Colombia', 'Colombian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Comoros', 'Comoran')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Congo, Republic of the', 'Congolese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Congo, Democratic Republic of the', 'Congolese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Costa Rica', 'Costa Rican')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Cote d”Ivoire', 'Ivorian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Croatia', 'Croatian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Cuba', 'Cuban')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Cyprus', 'Cypriot')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Czech Republic', 'Czech')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Denmark', 'Danish')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Djibouti', 'Djibouti')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Dominica', 'Dominican')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Dominican Republic', 'Dominican')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'East Timor', 'East Timorese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Ecuador', 'Ecuadorean')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Egypt', 'Egyptian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'El Salvador', 'Salvadoran')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Equatorial Guinea', 'Equatorial Guinean')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Eritrea', 'Eritrean')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Estonia', 'Estonian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Ethiopia', 'Ethiopian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Fiji', 'Fijian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Finland', 'Finnish')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'France', 'French')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Gabon', 'Gabonese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'The Gambia', 'Gambian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Georgia', 'Georgian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Germany', 'German')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Ghana', 'Ghanaian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Greece', 'Greek')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Grenada', 'Grenadian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Guatemala', 'Guatemalan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Guinea', 'Guinean')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Guinea-Bissau', 'Guinea-Bissauan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Guyana', 'Guyanese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Haiti', 'Haitian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Honduras', 'Honduran')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Hungary', 'Hungarian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Iceland', 'Icelander')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'India', 'Indian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Indonesia', 'Indonesian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Iran', 'Iranian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Iraq', 'Iraqi')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Ireland', 'Irish')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Israel', 'Israeli')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Italy', 'Italian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Jamaica', 'Jamaican')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Japan', 'Japanese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Jordan', 'Jordanian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Kazakhstan', 'Kazakhstani')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Kenya', 'Kenyan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Kiribati', 'I-Kiribati')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Korea, North', 'North Korean')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Korea, South', 'South Korean')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Kuwait', 'Kuwaiti')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Kyrgyz Republic', 'Kirghiz')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Laos', 'Laotian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Latvia', 'Latvian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Lebanon', 'Lebanese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Lesotho', 'Mosotho')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Liberia', 'Liberian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Libya', 'Libyan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Liechtenstein', 'Liechtensteiner')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Lithuania', 'Lithuanian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Luxembourg', 'Luxembourger')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Macedonia', 'Macedonian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Madagascar', 'Malagasy')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Malawi', 'Malawian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Malaysia', 'Malaysian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Maldives', 'Maldivan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Mali', 'Malian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Malta', 'Maltese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Marshall Islands', 'Marshallese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Mauritania', 'Mauritanian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Mauritius', 'Mauritian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Mexico', 'Mexican')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Federated States of Micronesia', 'Micronesian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Moldova', 'Moldovan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Monaco', 'Monegasque')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Mongolia', 'Mongolian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Morocco', 'Moroccan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Mozambique', 'Mozambican')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Myanmar (Burma)', 'Burmese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Namibia', 'Namibian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Nauru', 'Nauruan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Nepal', 'Nepalese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Netherlands', 'Dutch')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'New Zealand', 'New Zealander')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Nicaragua', 'Nicaraguan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Niger', 'Nigerien')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Nigeria', 'Nigerian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Norway', 'Norwegian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Oman', 'Omani')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Pakistan', 'Pakistani')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Palau', 'Palauan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Panama', 'Panamanian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Papua New Guinea', 'Papua New Guinean')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Paraguay', 'Paraguayan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Peru', 'Peruvian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Philippines', 'Filipino')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Poland', 'Polish')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Portugal', 'Portuguese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Qatar', 'Qatari')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Romania', 'Romanian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Russia', 'Russian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Rwanda', 'Rwandan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Saint Kitts and Nevis', 'Kittian and Nevisian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Saint Lucia', 'Saint Lucian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Samoa', 'Samoan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'San Marino', 'Sammarinese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Sao Tome and Principe', 'Sao Tomean')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Saudi Arabia', 'Saudi Arabian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Senegal', 'Senegalese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Serbia and Montenegro', 'Serbian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Seychelles', 'Seychellois')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Sierra Leone', 'Sierra Leonean')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Singapore', 'Singaporean')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Slovakia', 'Slovak')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Slovenia', 'Slovene')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Solomon Islands', 'Solomon Islander')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Somalia', 'Somali')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'South Africa', 'South African')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Spain', 'Spanish')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Sri Lanka', 'Sri Lankan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Sudan', 'Sudanese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Suriname', 'Surinamer')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Swaziland', 'Swazi')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Sweden', 'Swedish')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Switzerland', 'Swiss')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Syria', 'Syrian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Taiwan', 'Taiwanese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Tajikistan', 'Tadzhik')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Tanzania', 'Tanzanian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Thailand', 'Thai')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Togo', 'Togolese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Tonga', 'Tongan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Trinidad and Tobago', 'Trinidadian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Tunisia', 'Tunisian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Turkey', 'Turkish')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Turkmenistan', 'Turkmen')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Tuvalu', 'Tuvaluan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Uganda', 'Ugandan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Ukraine', 'Ukrainian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'United Arab Emirates', 'Emirian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'United Kingdom', 'British')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values ('United States', 'American')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Uruguay', 'Uruguayan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Uzbekistan', 'Uzbekistani')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Vanuatu', 'Ni-Vanuatu')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Vatican City (Holy See)', 'none')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Venezuela', 'Venezuelan')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Vietnam', 'Vietnamese')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Yemen', 'Yemeni')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Zambia', 'Zambian')
INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Zimbabwe', 'Zimbabwean')
2) On your MS SQL Enterprise manager(2000 ot later) , then look for your database where you want to place the table for Country
3)Create a table namely "Country"
4) Add the following fields on your table :
* CountryID - You may opt to this as your primary key and make it default value into AUTONUMER or by doing that just make it as Identity Seed = "Yes"
*Name - Country Name
*Nationality - Nationality that corresponds to County
Note : you may add other fields aside from the 3 fields I provided, just be sure to set all fields with default values
5)Save the table and label it with "Country"
6)Go to SQL Query analyzer
7) Open the Script or Copy the Scripts/SQL Commands
8) Paste it at the Query analyzer
9) Finally, Press "F5"
10) Then viola! select your "Country" table , in this way "SELECT * FROM COUNTRY"
I Hope this might help (^_^)!
Comments
Post a Comment