SQLserver创建省市县三级联动的建表代码

省

 DROP TABLE [province]
 CREATE TABLE [province] (  [id] [int] NOT NULL , [provinceID] [char] (6) NULL , [province] [nvarchar] (40) NULL )

 INSERT [province] ( [id] , [provinceID] , [province] ) VALUES ( 1 , '110000' , '北京市' )
 INSERT [province] ( [id] , [provinceID] , [province] ) VALUES ( 2 , '120000' , '天津市' )
 INSERT [province] ( [id] , [provinceID] , [province] ) VALUES ( 3 , '130000' , '河北省' )

 市

 DROP TABLE [city]
 CREATE TABLE [city] (  [id] [int] NOT NULL , [cityID] [char] (6) NULL , [city] [nvarchar] (50) NULL , [father] [char] (6) NULL )

 INSERT [city] ( [id] , [cityID] , [city] , [father] ) VALUES ( 1 , '110100' , '市辖区' , '110000' )
 INSERT [city] ( [id] , [cityID] , [city] , [father] ) VALUES ( 2 , '110200' , '县' , '110000' )
 INSERT [city] ( [id] , [cityID] , [city] , [father] ) VALUES ( 3 , '120100' , '市辖区' , '120000' )
 INSERT [city] ( [id] , [cityID] , [city] , [father] ) VALUES ( 4 , '120200' , '县' , '120000' )
 INSERT [city] ( [id] , [cityID] , [city] , [father] ) VALUES ( 5 , '130100' , '石家庄市' , '130000' )
 INSERT [city] ( [id] , [cityID] , [city] , [father] ) VALUES ( 6 , '130200' , '唐山市' , '130000' )
 INSERT [city] ( [id] , [cityID] , [city] , [father] ) VALUES ( 7 , '130300' , '秦皇岛市' , '130000' )
 INSERT [city] ( [id] , [cityID] , [city] , [father] ) VALUES ( 8 , '130400' , '邯郸市' , '130000' )
 INSERT [city] ( [id] , [cityID] , [city] , [father] ) VALUES ( 9 , '130500' , '邢台市' , '130000' )
 INSERT [city] ( [id] , [cityID] , [city] , [father] ) VALUES ( 10 , '130600' , '保定市' , '130000' )
 INSERT [city] ( [id] , [cityID] , [city] , [father] ) VALUES ( 11 , '130700' , '张家口市' , '130000' )
 INSERT [city] ( [id] , [cityID] , [city] , [father] ) VALUES ( 12 , '130800' , '承德市' , '130000' )
 INSERT [city] ( [id] , [cityID] , [city] , [father] ) VALUES ( 13 , '130900' , '沧州市' , '130000' )
 INSERT [city] ( [id] , [cityID] , [city] , [father] ) VALUES ( 14 , '131000' , '廊坊市' , '130000' )
 INSERT [city] ( [id] , [cityID] , [city] , [father] ) VALUES ( 15 , '131100' , '衡水市' , '130000' )

 

县

 DROP TABLE [area]
 CREATE TABLE [area] (  [id] [int] NOT NULL , [areaID] [char] (6) NULL , [area] [nvarchar] (60) NULL , [father] [char] (6) NULL )

 INSERT [area] ( [id] , [areaID] , [area] , [father] ) VALUES ( 1 , '110101' , '东城区' , '110100' )
 INSERT [area] ( [id] , [areaID] , [area] , [father] ) VALUES ( 2 , '110102' , '西城区' , '110100' )

INSERT [area] ( [id] , [areaID] , [area] , [father] ) VALUES ( 21 , '120103' , '河西区' , '120100' )
 INSERT [area] ( [id] , [areaID] , [area] , [father] ) VALUES ( 22 , '120104' , '南开区' , '120100' )
 INSERT [area] ( [id] , [areaID] , [area] , [father] ) VALUES ( 23 , '120105' , '河北区' , '120100' )
 INSERT [area] ( [id] , [areaID] , [area] , [father] ) VALUES ( 24 , '120106' , '红桥区' , '120100' )
 INSERT [area] ( [id] , [areaID] , [area] , [father] ) VALUES ( 25 , '120107' , '塘沽区' , '120100' )
 INSERT [area] ( [id] , [areaID] , [area] , [father] ) VALUES ( 26 , '120108' , '汉沽区' , '120100' )
 INSERT [area] ( [id] , [areaID] , [area] , [father] ) VALUES ( 27 , '120109' , '大港区' , '120100' )
 INSERT [area] ( [id] , [areaID] , [area] , [father] ) VALUES ( 28 , '120110' , '东丽区' , '120100' )
 INSERT [area] ( [id] , [areaID] , [area] , [father] ) VALUES ( 29 , '120111' , '西青区' , '120100' )
 INSERT [area] ( [id] , [areaID] , [area] , [father] ) VALUES ( 30 , '120112' , '津南区' , '120100' )
 INSERT [area] ( [id] , [areaID] , [area] , [father] ) VALUES ( 31 , '120113' , '北辰区' , '120100' )
 INSERT [area] ( [id] , [areaID] , [area] , [father] ) VALUES ( 32 , '120114' , '武清区' , '120100' )

INSERT [area] ( [id] , [areaID] , [area] , [father] ) VALUES ( 38 , '130102' , '长安区' , '130100' )
 INSERT [area] ( [id] , [areaID] , [area] , [father] ) VALUES ( 39 , '130103' , '桥东区' , '130100' )
 INSERT [area] ( [id] , [areaID] , [area] , [father] ) VALUES ( 40 , '130104' , '桥西区' , '130100' )
 INSERT [area] ( [id] , [areaID] , [area] , [father] ) VALUES ( 41 , '130105' , '新华区' , '130100' )
 INSERT [area] ( [id] , [areaID] , [area] , [father] ) VALUES ( 42 , '130107' , '井陉矿区' , '130100' )
 INSERT [area] ( [id] , [areaID] , [area] , [father] ) VALUES ( 43 , '130108' , '裕华区' , '130100' )
 INSERT [area] ( [id] , [areaID] , [area] , [father] ) VALUES ( 44 , '130121' , '井陉县' , '130100' )
 INSERT [area] ( [id] , [areaID] , [area] , [father] ) VALUES ( 45 , '130123' , '正定县' , '130100' )
 INSERT [area] ( [id] , [areaID] , [area] , [father] ) VALUES ( 46 , '130124' , '栾城县' , '130100' )
 INSERT [area] ( [id] , [areaID] , [area] , [father] ) VALUES ( 47 , '130125' , '行唐县' , '130100' )
 INSERT [area] ( [id] , [areaID] , [area] , [father] ) VALUES ( 48 , '130126' , '灵寿县' , '130100' )