You forgot about 'Isle of Man'
Thanks :D

dude that must of been hard enough already.

insert into tbl_Counties (CountryID, Name)
select 1, 'Bedfordshire'
union select 1, 'Berkshire'
union select 1, 'Bristol'
union select 1, 'Buckinghamshire'
union select 1, 'Cambridgeshire'
union select 1, 'Cheshire'
union select 1, 'City of London'
union select 1, 'Cornwall'
union select 1, 'Cumbria'
union select 1, 'Derbyshire'
union select 1, 'Devon'
union select 1, 'Dorset'
union select 1, 'Durham'
union select 1, 'East Riding of Yorkshire'
union select 1, 'East Sussex'
union select 1, 'Essex'
union select 1, 'Gloucestershire'
union select 1, 'Greater London'
union select 1, 'Greater Manchester'
union select 1, 'Hampshire'
union select 1, 'Herefordshire'
union select 1, 'Hertfordshire'
union select 1, 'Isle of Wight'
union select 1, 'Kent'
union select 1, 'Lancashire'
union select 1, 'Leicestershire'
union select 1, 'Lincolnshire'
union select 1, 'Merseyside'
union select 1, 'Norfolk'
union select 1, 'North Yorkshire'
union select 1, 'Northamptonshire'
union select 1, 'Northumberland'
union select 1, 'Nottinghamshire'
union select 1, 'Oxfordshire'
union select 1, 'Rutland'
union select 1, 'Shropshire'
union select 1, 'Somerset'
union select 1, 'South Yorkshire'
union select 1, 'Staffordshire'
union select 1, 'Suffolk'
union select 1, 'Surrey'
union select 1, 'Tyne and Wear'
union select 1, 'Warwickshire'
union select 1, 'West Midlands'
union select 1, 'West Sussex'
union select 1, 'West Yorkshire'
union select 1, 'Wiltshire'
union select 1, 'Worcestershire'
union select 2, 'Aberdeenshire'
union select 2, 'Angus'
union select 2, 'Argyllshire'
union select 2, 'Ayrshire'
union select 2, 'Banffshire'
union select 2, 'Berwickshire'
union select 2, 'Buteshire'
union select 2, 'Cromartyshire'
union select 2, 'Caithness'
union select 2, 'Clackmannanshire'
union select 2, 'Dumfriesshire'
union select 2, 'Dunbartonshire'
union select 2, 'East Lothian'
union select 2, 'Fife'
union select 2, 'Inverness-shire'
union select 2, 'Kincardineshire'
union select 2, 'Kinross'
union select 2, 'Kirkcudbrightshire'
union select 2, 'Lanarkshire'
union select 2, 'Midlothian'
union select 2, 'Morayshire'
union select 2, 'Nairnshire'
union select 2, 'Orkney'
union select 2, 'Peeblesshire'
union select 2, 'Perthshire'
union select 2, 'Renfrewshire'
union select 2, 'Ross-shire'
union select 2, 'Roxburghshire'
union select 2, 'Selkirkshire'
union select 2, 'Shetland'
union select 2, 'Stirlingshire'
union select 2, 'Sutherland'
union select 2, 'West Lothian'
union select 2, 'Wigtownshire'
union select 3, 'Anglesey'
union select 3, 'Brecknockshire'
union select 3, 'Caernarfonshire'
union select 3, 'Carmarthenshire'
union select 3, 'Cardiganshire'
union select 3, 'Denbighshire'
union select 3, 'Flintshire'
union select 3, 'Glamorgan'
union select 3, 'Merioneth'
union select 3, 'Monmouthshire'
union select 3, 'Montgomeryshire'
union select 3, 'Pembrokeshire'
union select 3, 'Radnorshire'
union select 4, 'Antrim'
union select 4, 'Armagh'
union select 4, 'Down'
union select 4, 'Fermanagh'
union select 4, 'Londonderry'
union select 4, 'Tyrone'

Hi there

The Isle of Man/Mann is not part of the United Kingdom, and so is not a county of the UK.

Hope this info helps.

Great! But not totally updated. I preferred to go for www.worldcitiesdatabase.com for uk cities database.

please join the geekpedia