SQLScripts for All countries, their states and city in world

Liladhar Nimje

11y1.3k

Hi All,

I am creating a database where I need to create tables like 'tblCountry' which will contains all countries in world with names, short name, country code and phone code.

Similarly for all countries in 'tblCountry'', I need to create table 'tblState' which will contains all states of that country with name and short name.

Similary for all states in 'tblState', I need to create table 'tblCity' which will contains all city of that state.

Each of these tables will be related to each other so that I can retrieve required data based on selected country, state and city.

Does any one having SQL scripts for the same?

Thanks in Advance.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kiran Roy11y ago
What you actually need ???
Follow Gowtham's Query to create tables.

And then insert data into those tables -

Insert Into tbl_country Values(1, 'Country_name')
Insert Into tbl_state Values(1, 'State_name')
Insert Into tbl_city Values(1, 'City_name')
0
Liladhar Nimje11y ago
Dear Gowtham,

I don't want script for creating table, I know that, I need the data for the table like all country, state and city in world.
-1
Gowtham K11y ago
Try this,
create table tbl_country
(
Country_ID int constraint Pk_Country_ID primary key,
Country_Name nvarchar(50)
)
create table tbl_state
(
State_ID int constraint Pk_State_ID primary key,
Country_ID int constraint Fk_Country_ID foreign key references tbl_country(Country_ID),
State_Name nvarchar(50),
)
create table tbl_city
(
City_ID int constraint Pk_City_ID primary key,
State_ID int constraint Fk_State_ID foreign key references tbl_state(State_ID),
City_Name nvarchar(50)
)

0