Indian State, District, City SQL Database

This is clean and neat database of Indian State, District, City SQL Database. Download link contains entire database of Indian State, District and city.

• State : This has 35 records.

CREATE TABLE state (
   state_id int(11) NOT NULL,
   state_title varchar(50) NOT NULL,
   state_description text NOT NULL,
   status varchar(10) NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

• District: This has 640 records.

CREATE TABLE district (
   districtid int(11) NOT NULL,
   state_id int(11) NOT NULL,
   district_title varchar(50) NOT NULL,
   district_description text NOT NULL,
   district_status varchar(10) NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

• City: This has 5924 city records.

CREATE TABLE city (
   id int(11) NOT NULL,
   name varchar(100) NOT NULL,
   districtid int(11) DEFAULT NULL,
   state_id int(11) DEFAULT NULL,
   description text NOT NULL,
   status varchar(10) DEFAULT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Download Link