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 TABLEstate
(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 TABLEdistrict
(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 TABLEcity
(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;