Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
SQLScripts for All countries, their states and city in world
Liladhar Nimje
Jun 20 2015 6:11 AM
553
Reply
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.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
How delete foriegn key in dbms who exist in other table?
sql server certification course