SQLScripts for All countries their states and city in world

Question

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.

Kiran Roy · Answer

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')

Gowtham K · Answer

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) )

Liladhar Nimje · Answer

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.

SQLScripts for All countries, their states and city in world