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.