USE pubs
GO

CREATE TABLE area_code_info
(
    [id] INT IDENTITY(1,1),
    area_code CHAR(6) PRIMARY KEY,
    area_name VARCHAR(36) NOT NULL
)

INSERT INTO area_code_info VALUES('110100','北京市市轄區(qū)')
INSERT INTO area_code_info VALUES('110101','北京市東城區(qū)')
INSERT INTO area_code_info VALUES('110102','北京市西城區(qū)')
INSERT INTO area_code_info VALUES('110103','北京市崇文區(qū)')
INSERT INTO area_code_info VALUES('110104','北京市宣武區(qū)')
INSERT INTO area_code_info VALUES('110105','北京市朝陽區(qū)')
INSERT INTO area_code_info VALUES('110106','北京市豐臺(tái)區(qū)')
INSERT INTO area_code_info VALUES('110107','北京市石景山區(qū)')
INSERT INTO area_code_info VALUES('110108','北京市海淀區(qū)')
INSERT INTO area_code_info VALUES('110109','北京市門頭溝區(qū)')
INSERT INTO area_code_info VALUES('110111','北京市房山區(qū)')
INSERT INTO area_code_info VALUES('110112','北京市通州區(qū)')
INSERT INTO area_code_info VALUES('110113','北京市順義區(qū)')
INSERT INTO area_code_info VALUES('110114','北京市昌平區(qū)')
INSERT INTO area_code_info VALUES('110115','北京市大興區(qū)')
INSERT INTO area_code_info VALUES('110116','北京市懷柔區(qū)')
INSERT INTO area_code_info VALUES('110117','北京市平谷區(qū)')
INSERT INTO area_code_info VALUES('110200','北京市北京市縣')
INSERT INTO area_code_info VALUES('110228','北京市密云縣')
INSERT INTO area_code_info VALUES('110229','北京市延慶縣')
INSERT INTO area_code_info VALUES('120000','天津市天津市')
INSERT INTO area_code_info VALUES('120100','天津市市轄區(qū)')
INSERT INTO area_code_info VALUES('120101','天津市和平區(qū)')
INSERT INTO area_code_info VALUES('120102','天津市河?xùn)|區(qū)')
INSERT INTO area_code_info VALUES('120103','天津市河西區(qū)')
INSERT INTO area_code_info VALUES('120104','天津市南開區(qū)')
INSERT INTO area_code_info VALUES('120105','天津市河北區(qū)')
INSERT INTO area_code_info VALUES('120106','天津市紅橋區(qū)')
INSERT INTO area_code_info VALUES('120107','天津市塘沽區(qū)')
INSERT INTO area_code_info VALUES('120108','天津市漢沽區(qū)')
INSERT INTO area_code_info VALUES('120109','天津市大港區(qū)')
INSERT INTO area_code_info VALUES('120110','天津市東麗區(qū)')
INSERT INTO area_code_info VALUES('120111','天津市西青區(qū)')
INSERT INTO area_code_info VALUES('120112','天津市津南區(qū)')
INSERT INTO area_code_info VALUES('120113','天津市北辰區(qū)')
INSERT INTO area_code_info VALUES('120114','天津市武清區(qū)')
INSERT INTO area_code_info VALUES('120115','天津市寶坻區(qū)')
INSERT INTO area_code_info VALUES('120200','天津市縣')
INSERT INTO area_code_info VALUES('120221','天津市寧河縣')
INSERT INTO area_code_info VALUES('120223','天津市靜海縣')
INSERT INTO area_code_info VALUES('120225','天津市薊縣')
INSERT INTO area_code_info VALUES('130000','河北省河北省')
INSERT INTO area_code_info VALUES('130100','河北省石家莊市')
INSERT INTO area_code_info VALUES('130101','河北省市轄區(qū)')
INSERT INTO area_code_info VALUES('130102','河北省長安區(qū)')
INSERT INTO area_code_info VALUES('130103','河北省橋東區(qū)')
INSERT INTO area_code_info VALUES('130104','河北省橋西區(qū)')
INSERT INTO area_code_info VALUES('130105','河北省新華區(qū)')
INSERT INTO area_code_info VALUES('130107','河北省井陘礦區(qū)')
INSERT INTO area_code_info VALUES('130108','河北省裕華區(qū)')
INSERT INTO area_code_info VALUES('130121','河北省井陘縣')
INSERT INTO area_code_info VALUES('130123','河北省正定縣')
INSERT INTO area_code_info VALUES('130124','河北省欒城縣')
INSERT INTO area_code_info VALUES('130125','河北省行唐縣')
INSERT INTO area_code_info VALUES('130126','河北省靈壽縣')
INSERT INTO area_code_info VALUES('130127','河北省高邑縣')
INSERT INTO area_code_info VALUES('130128','河北省深澤縣')
INSERT INTO area_code_info VALUES('130129','河北省贊皇縣')
INSERT INTO area_code_info VALUES('130130','河北省無極縣')
INSERT INTO area_code_info VALUES('130131','河北省平山縣')
INSERT INTO area_code_info VALUES('130132','河北省元氏縣')
INSERT INTO area_code_info VALUES('130133','河北省趙縣')
INSERT INTO area_code_info VALUES('130181','河北省辛集市')
INSERT INTO area_code_info VALUES('130182','河北省藁城市')
INSERT INTO area_code_info VALUES('130183','河北省晉州市')
INSERT INTO area_code_info VALUES('130184','河北省新樂市')
INSERT INTO area_code_info VALUES('130185','河北省鹿泉市')
INSERT INTO area_code_info VALUES('130200','河北省唐山市')
INSERT INTO area_code_info VALUES('130201','河北省市轄區(qū)')
INSERT INTO area_code_info VALUES('130202','河北省路南區(qū)')
INSERT INTO area_code_info VALUES('130203','河北省路北區(qū)')
INSERT INTO area_code_info VALUES('130204','河北省古冶區(qū)')
INSERT INTO area_code_info VALUES('130205','河北省開平區(qū)')
INSERT INTO area_code_info VALUES('130207','河北省豐南區(qū)')
INSERT INTO area_code_info VALUES('130208','河北省豐潤區(qū)')
INSERT INTO area_code_info VALUES('130223','河北省灤縣')
INSERT INTO area_code_info VALUES('130224','河北省灤南縣')
INSERT INTO area_code_info VALUES('130225','河北省樂亭縣')
INSERT INTO area_code_info VALUES('130227','河北省遷西縣')
INSERT INTO area_code_info VALUES('130229','河北省玉田縣')
INSERT INTO area_code_info VALUES('130230','河北省唐?？h')
INSERT INTO area_code_info VALUES('130281','河北省遵化市')
INSERT INTO area_code_info VALUES('130283','河北省遷安市')
INSERT INTO area_code_info VALUES('130300','河北省秦皇島市')
INSERT INTO area_code_info VALUES('130301','河北省市轄區(qū)')
INSERT INTO area_code_info VALUES('130302','河北省海港區(qū)')
INSERT INTO area_code_info VALUES('130303','河北省山海關(guān)區(qū)')
INSERT INTO area_code_info VALUES('130304','河北省北戴河區(qū)')
INSERT INTO area_code_info VALUES('130321','河北省青龍滿族自治縣')
INSERT INTO area_code_info VALUES('130322','河北省昌黎縣')
INSERT INTO area_code_info VALUES('130323','河北省撫寧縣')
INSERT INTO area_code_info VALUES('130324','河北省盧龍縣')
INSERT INTO area_code_info VALUES('130400','河北省邯鄲市')
INSERT INTO area_code_info VALUES('130401','河北省市轄區(qū)')
INSERT INTO area_code_info VALUES('130402','河北省邯山區(qū)')
INSERT INTO area_code_info VALUES('130403','河北省叢臺(tái)區(qū)')
INSERT INTO area_code_info VALUES('130404','河北省復(fù)興區(qū)')
INSERT INTO area_code_info VALUES('130406','河北省峰峰礦區(qū)')
INSERT INTO area_code_info VALUES('130421','河北省邯鄲縣')
INSERT INTO area_code_info VALUES('130423','河北省臨漳縣')
INSERT INTO area_code_info VALUES('130424','河北省成安縣')
INSERT INTO area_code_info VALUES('130425','河北省大名縣')
INSERT INTO area_code_info VALUES('130426','河北省涉縣')
INSERT INTO area_code_info VALUES('130427','河北省磁縣')
INSERT INTO area_code_info VALUES('130428','河北省肥鄉(xiāng)縣')
INSERT INTO area_code_info VALUES('130429','河北省永年縣')
INSERT INTO area_code_info VALUES('130430','河北省邱縣')
INSERT INTO area_code_info VALUES('130431','河北省雞澤縣')
INSERT INTO area_code_info VALUES('130432','河北省廣平縣')
INSERT INTO area_code_info VALUES('130433','河北省館陶縣')
INSERT INTO area_code_info VALUES('130434','河北省魏縣')
INSERT INTO area_code_info VALUES('130435','河北省曲周縣')
INSERT INTO area_code_info VALUES('130481','河北省武安市')
INSERT INTO area_code_info VALUES('130500','河北省邢臺(tái)市')
INSERT INTO area_code_info VALUES('130501','河北省市轄區(qū)')
INSERT INTO area_code_info VALUES('130502','河北省橋東區(qū)')
INSERT INTO area_code_info VALUES('130503','河北省橋西區(qū)')
INSERT INTO area_code_info VALUES('130521','河北省邢臺(tái)縣')
INSERT INTO area_code_info VALUES('130522','河北省臨城縣')
INSERT INTO area_code_info VALUES('130523','河北省內(nèi)丘縣')
INSERT INTO area_code_info VALUES('130524','河北省柏鄉(xiāng)縣')
INSERT INTO area_code_info VALUES('130525','河北省隆堯縣')
INSERT INTO area_code_info VALUES('130526','河北省任縣')
INSERT INTO area_code_info VALUES('130527','河北省南和縣')
INSERT INTO area_code_info VALUES('130528','河北省寧晉縣')
INSERT INTO area_code_info VALUES('130529','河北省巨鹿縣')
INSERT INTO area_code_info VALUES('130530','河北省新河縣')
INSERT INTO area_code_info VALUES('130531','河北省廣宗縣')
INSERT INTO area_code_info VALUES('130532','河北省平鄉(xiāng)縣')
INSERT INTO area_code_info VALUES('130533','河北省威縣')
INSERT INTO area_code_info VALUES('130534','河北省清河縣')
INSERT INTO area_code_info VALUES('130535','河北省臨西縣')
INSERT INTO area_code_info VALUES('130581','河北省南宮市')
INSERT INTO area_code_info VALUES('130582','河北省沙河市')
INSERT INTO area_code_info VALUES('130600','河北省保定市')
INSERT INTO area_code_info VALUES('130601','河北省市轄區(qū)')
INSERT INTO area_code_info VALUES('130602','河北省新市區(qū)')
INSERT INTO area_code_info VALUES('130603','河北省北市區(qū)')
INSERT INTO area_code_info VALUES('130604','河北省南市區(qū)')
INSERT INTO area_code_info VALUES('130621','河北省滿城縣')
INSERT INTO area_code_info VALUES('130622','河北省清苑縣')
INSERT INTO area_code_info VALUES('130623','河北省淶水縣')
INSERT INTO area_code_info VALUES('130624','河北省阜平縣')
INSERT INTO area_code_info VALUES('130625','河北省徐水縣')
INSERT INTO area_code_info VALUES('130626','河北省定興縣')
INSERT INTO area_code_info VALUES('130627','河北省唐縣')
INSERT INTO area_code_info VALUES('130628','河北省高陽縣')
INSERT INTO area_code_info VALUES('130629','河北省容城縣')
INSERT INTO area_code_info VALUES('130630','河北省淶源縣')
INSERT INTO area_code_info VALUES('130631','河北省望都縣')
INSERT INTO area_code_info VALUES('130632','河北省安新縣')
INSERT INTO area_code_info VALUES('130633','河北省易縣')
INSERT INTO area_code_info VALUES('130634','河北省曲陽縣')
INSERT INTO area_code_info VALUES('130635','河北省蠡縣')
INSERT INTO area_code_info VALUES('130636','河北省順平縣')
INSERT INTO area_code_info VALUES('130637','河北省博野縣')
INSERT INTO area_code_info VALUES('130638','河北省雄縣')
INSERT INTO area_code_info VALUES('130681','河北省涿州市')
INSERT INTO area_code_info VALUES('130682','河北省定州市')
INSERT INTO area_code_info VALUES('130683','河北省安國市')
INSERT INTO area_code_info VALUES('130684','河北省高碑店市')
INSERT INTO area_code_info VALUES('130700','河北省張家口市')
INSERT INTO area_code_info VALUES('130701','河北省市轄區(qū)')
INSERT INTO area_code_info VALUES('130702','河北省橋東區(qū)')
INSERT INTO area_code_info VALUES('130703','河北省橋西區(qū)')
INSERT INTO area_code_info VALUES('130705','河北省宣化區(qū)')
INSERT INTO area_code_info VALUES('130706','河北省下花園區(qū)')
INSERT INTO area_code_info VALUES('130721','河北省宣化縣')
INSERT INTO area_code_info VALUES('130722','河北省張北縣')
INSERT INTO area_code_info VALUES('130723','河北省康?？h')
INSERT INTO area_code_info VALUES('130724','河北省沽源縣')
INSERT INTO area_code_info VALUES('130725','河北省尚義縣')
INSERT INTO area_code_info VALUES('130726','河北省蔚縣')
INSERT INTO area_code_info VALUES('130727','河北省陽原縣')
INSERT INTO area_code_info VALUES('130728','河北省懷安縣')
INSERT INTO area_code_info VALUES('130729','河北省萬全縣')
INSERT INTO area_code_info VALUES('130730','河北省懷來縣')
INSERT INTO area_code_info VALUES('130731','河北省涿鹿縣')
INSERT INTO area_code_info VALUES('130732','河北省赤城縣')
INSERT INTO area_code_info VALUES('130733','河北省崇禮縣')
INSERT INTO area_code_info VALUES('130800','河北省承德市')
INSERT INTO area_code_info VALUES('130801','河北省市轄區(qū)')
INSERT INTO area_code_info VALUES('130802','河北省雙橋區(qū)')