Country-Region-City MSSQL ready-to-use scripts
This is an adaptation from MySQL to MSSQL.
Original scripts:
https://github.com/prograhammer/countries-regions-cities
- Open Visual Studio SQL Server Object Explorer or Microsoft SQL Server Management Studio
- Create a database with the name you want and select it
- Execute the scripts in the order that they appear (cities insert will take a few minutes)
| Column |
Type |
Description |
| Id |
SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT |
Primary Key for a Country |
| Name |
VARCHAR(255) NOT NULL |
Country name |
| Code |
VARCHAR(2) NOT NULL |
Country abbreviation |
| Language |
VARCHAR(3) NOT NULL |
Language code |
Regions table (regions/provinces/states)
| Column |
Type |
Description |
| Id |
INT(11) UNSIGNED NOT NULL AUTO_INCREMENT |
Primary Key for a Region |
| Name |
VARCHAR(255) NOT NULL |
Region name |
| CountryId |
SMALLINT(5) UNSIGNED NOT NULL |
Foreign key to Countries table |
| Column |
Type |
Description |
| Id |
INT(11) UNSIGNED NOT NULL AUTO_INCREMENT |
Primary Key for a City |
| Name |
VARCHAR(255) NOT NULL |
City name |
| RegionId |
INT(11) UNSIGNED NOT NULL |
Foreign key to Regions table |
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent