Sql Server Script for the List of all Country State and City


  • I am searching for the Sql Server Script of all country State and City with the Following type

    For the Country only 2 Columns are there i.e. CountryId and CountryName(CountryId is primary Key)

    For the State 3 Columns are there i.e. CountryId, StateId and StateName(StateId is Primary Key and CountryId is Foreign Key)

    For the City 3 Columns are there i.e. StateId ,CityId and CityName(CityId is PrimaryKey and StateId is foreign Key).

    I need this type of Script with Column name. plzzz help me out i m stuck i didnt get the list as i want.

    Thanx and Regrads,

    • Moved by Olaf HelperMVP Wednesday, August 20, 2014 7:47 AM Moved from "SQL Database Engine" to a more specific forum
    Wednesday, August 20, 2014 7:41 AM


All replies