中國行政區(qū)域明細-sql腳本

1、中國行政區(qū)域明細數(shù)據(jù)庫腳本（SQL）創(chuàng)建省級表CREATETABLET_Province(ProIDINTIDENTITY(11)PRIMARYKEY省份主鍵ProNameNVAR(50)NOTNULL省份名稱ProStINT省份排序PremarkNVAR(50)說明)GoT_Province(ProNameProStPremark)Values(北京市1直轄市)T_Province(ProNameProStPremark)Values

2、(天津市2直轄市)T_Province(ProNameProStPremark)Values(河北省5省份)T_Province(ProNameProStPremark)Values(山西省6省份)T_Province(ProNameProStPremark)Values(內(nèi)蒙古自治區(qū)32自治區(qū))T_Province(ProNameProStPremark)Values(遼寧省8省份)T_Province(ProNameProStPre

3、mark)Values(吉林省9省份)T_Province(ProNameProStPremark)Values(黑龍江省10省份)T_Province(ProNameProStPremark)Values(上海市3直轄市)T_Province(ProNameProStPremark)Values(江蘇省11省份)T_Province(ProNameProStPremark)Values(浙江省12省份)T_Province(ProNa

4、meProStPremark)Values(安徽省13省份)T_Province(ProNameProStPremark)Values(福建省14省份)T_Province(ProNameProStPremark)Values(江西省15省份)T_Province(ProNameProStPremark)Values(山東省16省份)T_Province(ProNameProStPremark)Values(河南省17省份)T_Prov

5、ince(ProNameProStPremark)Values(湖北省18省份)T_Province(ProNameProStPremark)Values(湖南省19省份)T_Province(ProNameProStPremark)Values(廣東省20省份)T_Province(ProNameProStPremark)Values(海南省24省份)T_Province(ProNameProStPremark)Values(廣西壯族

6、自治區(qū)28自治區(qū))T_Province(ProNameProStPremark)Values(甘肅省21省份)T_Province(ProNameProStPremark)Values(陜西省27省份)T_Province(ProNameProStPremark)Values(新疆維吾爾自治區(qū)31自治區(qū))T_Province(ProNameProStPremark)Values(青海省26省份)T_Province(ProNamePro

7、StPremark)Values(寧夏回族自治區(qū)30自治區(qū))T_Province(ProNameProStPremark)Values(重慶市4直轄市)T_Province(ProNameProStPremark)Values(四川省22省份)T_Province(ProNameProStPremark)Values(貴州省23省份)T_Province(ProNameProStPremark)Values(云南省25省份)T_Prov

8、ince(ProNameProStPremark)Values(西藏自治區(qū)29自治區(qū))T_Province(ProNameProStPremark)Values(臺灣省7省份)T_City(CityNameProIDCitySt)Values(撫順市631)T_City(CityNameProIDCitySt)Values(本溪市632)T_City(CityNameProIDCitySt)Values(丹東市633)T_City(Ci

9、tyNameProIDCitySt)Values(錦州市634)T_City(CityNameProIDCitySt)Values(營口市635)T_City(CityNameProIDCitySt)Values(阜新市636)T_City(CityNameProIDCitySt)Values(遼陽市637)T_City(CityNameProIDCitySt)Values(朝陽市638)T_City(CityNameProIDCity

10、St)Values(盤錦市639)T_City(CityNameProIDCitySt)Values(葫蘆島市640)T_City(CityNameProIDCitySt)Values(長春市741)T_City(CityNameProIDCitySt)Values(吉林市742)T_City(CityNameProIDCitySt)Values(延邊朝鮮族自治州743)T_City(CityNameProIDCitySt)Values

11、(四平市744)T_City(CityNameProIDCitySt)Values(通化市745)T_City(CityNameProIDCitySt)Values(白城市746)T_City(CityNameProIDCitySt)Values(遼源市747)T_City(CityNameProIDCitySt)Values(松原市748)T_City(CityNameProIDCitySt)Values(白山市749)T_City(

12、CityNameProIDCitySt)Values(哈爾濱市850)T_City(CityNameProIDCitySt)Values(齊齊哈爾市851)T_City(CityNameProIDCitySt)Values(雞西市852)T_City(CityNameProIDCitySt)Values(牡丹江市853)T_City(CityNameProIDCitySt)Values(七臺河市854)T_City(CityNamePr

13、oIDCitySt)Values(佳木斯市855)T_City(CityNameProIDCitySt)Values(鶴崗市856)T_City(CityNameProIDCitySt)Values(雙鴨山市857)T_City(CityNameProIDCitySt)Values(綏化市858)T_City(CityNameProIDCitySt)Values(黑河市859)T_City(CityNameProIDCitySt)Val

14、ues(大興安嶺地區(qū)860)T_City(CityNameProIDCitySt)Values(伊春市861)T_City(CityNameProIDCitySt)Values(大慶市862)T_City(CityNameProIDCitySt)Values(南京市1063)T_City(CityNameProIDCitySt)Values(無錫市1064)T_City(CityNameProIDCitySt)Values(鎮(zhèn)江市106

15、5)T_City(CityNameProIDCitySt)Values(蘇州市1066)T_City(CityNameProIDCitySt)Values(南通市1067)T_City(CityNameProIDCitySt)Values(揚州市1068)T_City(CityNameProIDCitySt)Values(鹽城市1069)T_City(CityNameProIDCitySt)Values(徐州市1070)T_City(C