CountryList SQL Script
I am working on a Custom DotNetNuke module. I wanted to have a DropDownList of all the countries in the world.
I had to google a little bit to find all the countries available, which I beleive are 222 countries.
I wanted to share with you the SQL Script I created.
You can download this script from the Files Area.
When you run this script using the Sql Query Analyzer, it will create the following:
- regionList table
- countryList table
- Insert 222 countries into the countryList table categorized by regions located at regionList table.
I am sure you will need this script in your work some time.
If there is still any country not listed, please let me know so that I update the script
For DNN Custom Modules' developers, I found later on that there is a dll in the bind folder of the DNN installation called CountryListBox, don't know what it is, but I guess it is related to country list or so.
Hope this helps,
Regards