USE [database]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[tblCountries](
	[Id] [varchar](3) NOT NULL,
	[Name] [nvarchar](200) NOT NULL,
 CONSTRAINT [PK_tblCountries] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

INSERT INTO dbo.tblCountries (Id,Name) VALUES ('AF','Afghanistan')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('AX','Åland Islands')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('AL','Albania')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('DZ','Algeria')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('AS','American Samoa')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('AD','Andorra')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('AO','Angola')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('AI','Anguilla')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('AQ','Antarctica')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('AG','Antigua and Barbuda')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('AR','Argentina')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('AM','Armenia')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('AW','Aruba')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('AU','Australia')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('AT','Austria')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('AZ','Azerbaijan')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('BS','Bahamas')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('BH','Bahrain')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('BD','Bangladesh')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('BB','Barbados')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('BY','Belarus')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('BE','Belgium')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('BZ','Belize')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('BJ','Benin')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('BM','Bermuda')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('BT','Bhutan')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('BO','Bolivia')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('BA','Bosnia and Herzegovina')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('BW','Botswana')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('BV','Bouvet Island')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('BR','Brazil')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('IO','British Indian Ocean Territory')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('BN','Brunei Darussalam')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('BG','Bulgaria')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('BF','Burkina Faso')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('BI','Burundi')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('KH','Cambodia')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('CM','Cameroon')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('CA','Canada')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('CV','Cape Verde')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('KY','Cayman Islands')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('CF','Central African Republic')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('TD','Chad')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('CL','Chile')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('CN','China')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('CX','Christmas Island')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('CC','Cocos (Keeling) Islands')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('CO','Colombia')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('KM','Comoros')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('CG','Congo')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('CD','Congo,The Democratic Republic of The')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('CK','Cook Islands')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('CR','Costa Rica')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('CI','Cote D''ivoire')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('HR','Croatia')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('CU','Cuba')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('CY','Cyprus')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('CZ','Czech Republic')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('DK','Denmark')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('DJ','Djibouti')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('DM','Dominica')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('DO','Dominican Republic')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('EC','Ecuador')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('EG','Egypt')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('SV','El Salvador')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('GQ','Equatorial Guinea')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('ER','Eritrea')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('EE','Estonia')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('ET','Ethiopia')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('FK','Falkland Islands (Malvinas)')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('FO','Faroe Islands')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('FJ','Fiji')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('FI','Finland')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('FR','France')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('GF','French Guiana')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('PF','French Polynesia')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('TF','French Southern Territories')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('GA','Gabon')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('GM','Gambia')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('GE','Georgia')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('DE','Germany')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('GH','Ghana')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('GI','Gibraltar')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('GR','Greece')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('GL','Greenland')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('GD','Grenada')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('GP','Guadeloupe')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('GU','Guam')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('GT','Guatemala')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('GG','Guernsey')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('GN','Guinea')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('GW','Guinea-bissau')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('GY','Guyana')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('HT','Haiti')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('HM','Heard Island and Mcdonald Islands')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('VA','Holy See (Vatican City State)')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('HN','Honduras')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('HK','Hong Kong')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('HU','Hungary')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('IS','Iceland')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('IN','India')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('ID','Indonesia')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('IR','Iran,Islamic Republic of')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('IQ','Iraq')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('IE','Ireland')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('IM','Isle of Man')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('IL','Israel')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('IT','Italy')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('JM','Jamaica')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('JP','Japan')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('JE','Jersey')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('JO','Jordan')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('KZ','Kazakhstan')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('KE','Kenya')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('KI','Kiribati')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('KP','Korea,Democratic People''s Republic of')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('KR','Korea,Republic of')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('KW','Kuwait')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('KG','Kyrgyzstan')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('LA','Lao People''s Democratic Republic')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('LV','Latvia')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('LB','Lebanon')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('LS','Lesotho')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('LR','Liberia')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('LY','Libyan Arab Jamahiriya')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('LI','Liechtenstein')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('LT','Lithuania')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('LU','Luxembourg')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('MO','Macao')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('MK','Macedonia,The Former Yugoslav Republic of')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('MG','Madagascar')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('MW','Malawi')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('MY','Malaysia')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('MV','Maldives')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('ML','Mali')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('MT','Malta')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('MH','Marshall Islands')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('MQ','Martinique')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('MR','Mauritania')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('MU','Mauritius')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('YT','Mayotte')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('MX','Mexico')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('FM','Micronesia,Federated States of')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('MD','Moldova,Republic of')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('MC','Monaco')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('MN','Mongolia')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('ME','Montenegro')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('MS','Montserrat')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('MA','Morocco')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('MZ','Mozambique')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('MM','Myanmar')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('NA','Namibia')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('NR','Nauru')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('NP','Nepal')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('NL','Netherlands')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('AN','Netherlands Antilles')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('NC','New Caledonia')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('NZ','New Zealand')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('NI','Nicaragua')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('NE','Niger')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('NG','Nigeria')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('NU','Niue')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('NF','Norfolk Island')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('MP','Northern Mariana Islands')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('NO','Norway')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('OM','Oman')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('PK','Pakistan')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('PW','Palau')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('PS','Palestinian Territory,Occupied')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('PA','Panama')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('PG','Papua New Guinea')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('PY','Paraguay')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('PE','Peru')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('PH','Philippines')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('PN','Pitcairn')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('PL','Poland')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('PT','Portugal')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('PR','Puerto Rico')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('QA','Qatar')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('RE','Reunion')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('RO','Romania')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('RU','Russian Federation')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('RW','Rwanda')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('SH','Saint Helena')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('KN','Saint Kitts and Nevis')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('LC','Saint Lucia')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('PM','Saint Pierre and Miquelon')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('VC','Saint Vincent and The Grenadines')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('WS','Samoa')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('SM','San Marino')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('ST','Sao Tome and Principe')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('SA','Saudi Arabia')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('SN','Senegal')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('RS','Serbia')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('SC','Seychelles')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('SL','Sierra Leone')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('SG','Singapore')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('SK','Slovakia')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('SI','Slovenia')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('SB','Solomon Islands')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('SO','Somalia')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('ZA','South Africa')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('GS','South Georgia and The South Sandwich Islands')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('ES','Spain')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('LK','Sri Lanka')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('SD','Sudan')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('SR','Suriname')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('SJ','Svalbard and Jan Mayen')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('SZ','Swaziland')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('SE','Sweden')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('CH','Switzerland')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('SY','Syrian Arab Republic')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('TW','Taiwan,Province of China')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('TJ','Tajikistan')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('TZ','Tanzania,United Republic of')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('TH','Thailand')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('TL','Timor-leste')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('TG','Togo')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('TK','Tokelau')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('TO','Tonga')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('TT','Trinidad and Tobago')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('TN','Tunisia')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('TR','Turkey')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('TM','Turkmenistan')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('TC','Turks and Caicos Islands')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('TV','Tuvalu')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('UG','Uganda')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('UA','Ukraine')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('AE','United Arab Emirates')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('GB','United Kingdom')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('US','United States')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('UM','United States Minor Outlying Islands')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('UY','Uruguay')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('UZ','Uzbekistan')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('VU','Vanuatu')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('VE','Venezuela')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('VN','Viet Nam')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('VG','Virgin Islands,British')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('VI','Virgin Islands,U.S.')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('WF','Wallis and Futuna')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('EH','Western Sahara')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('YE','Yemen')
INSERT INTO dbo.tblCountries (Id,Name) VALUES ('ZM','Zambia')
GO