if exists (select 1
from sysobjects
where id = object_id('dbo.sys_area')
and type = 'U')
drop table dbo.sys_area
go
/*==============================================================*/
/* Table: sys_area */
/*==============================================================*/
create table dbo.sys_area (
area_code varchar(6) collate Chinese_PRC_CI_AS not null,
area_name varchar(70) collate Chinese_PRC_CI_AS not null,
constraint PK_Area primary key (area_code)
on "PRIMARY"
)
on "PRIMARY"
go
execute sp_addextendedproperty 'MS_Description',
'地区表',
'user', 'dbo', 'table', 'sys_area'
go
insert into sys_area(area_code,area_name) values('110101','东城区');
insert into sys_area(area_code,area_name) values('110102','西城区');
insert into sys_area(area_code,area_name) values('110103','崇文区');
insert into sys_area(area_code,area_name) values('110104','宣武区');
insert into sys_area(area_code,area_name) values('110105','朝阳区');
insert into sys_area(area_code,area_name) values('110106','丰台区');
insert into sys_area(area_code,area_name) values('110107','石景山区');
insert into sys_area(area_code,area_name) values('110108','海淀区');
insert into sys_area(area_code,area_name) values('110109','门头沟区');
insert into sys_area(area_code,area_name) values('110111','房山区');
insert into sys_area(area_code,area_name) values('110112','通州区');
insert into sys_area(area_code,area_name) values('110113','顺义区');
insert into sys_area(area_code,area_name) values('110114','昌平区');
insert into sys_area(area_code,area_name) values('110115','大兴区');
insert into sys_area(area_code,area_name) values('110116','怀柔区');
insert into sys_area(area_code,area_name) values('110117','平谷区');
insert into sys_area(area_code,area_name) values('110228','密云县');
insert into sys_area(area_code,area_name) values('110229','延庆县');
insert into sys_area(area_code,area_name) values('120101','和平区');
insert into sys_area(area_code,area_name) values('120102','河东区');
insert into sys_area(area_code,area_name) values('120103','河西区');
insert into sys_area(area_code,area_name) values('120104','南开区');
insert into sys_area(area_code,area_name) values('120105','河北区');
insert into sys_area(area_code,area_name) values('120106','红桥区');
insert into sys_area(area_code,area_name) values('120107','塘沽区');
insert into sys_area(area_code,area_name) values('120108','汉沽区');
insert into sys_area(area_code,area_name) values('120109','大港区');
insert into sys_area(area_code,area_name) values('120110','东丽区');
insert into sys_area(area_code,area_name) values('120111','西青区');
insert into sys_area(area_code,area_name) values('120112','津南区');
insert into sys_area(area_code,area_name) values('120113','北辰区');
insert into sys_area(area_code,area_name) values('120114','武清区');
insert into sys_area(area_code,area_name) values('120115','宝坻区');
insert into sys_area(area_code,area_name) values('120221','宁河县');
insert into sys_area(area_code,area_name) values('120223','静海县');
insert into sys_area(area_code,area_name) values('120225','蓟 县');
insert into sys_area(area_code,area_name) values('130101','市辖区');
insert into sys_area(area_code,area_name) values('130102','长安区');
insert into sys_area(area_code,area_name) values('130103','桥东区');
insert into sys_area(area_code,area_name) values('130104','桥西区');
insert into sys_area(area_code,area_name) values('130105','新华区');
insert into sys_area(area_code,area_name) values('130107','井陉矿区');
insert into sys_area(area_code,area_name) values('130108','裕华区');
insert into sys_area(area_code,area_name) values('130121','井陉县');
insert into sys_area(area_code,area_name) values('130123','正定县');
insert into sys_area(area_code,area_name) values('130124','栾城县');
insert into sys_area(area_code,area_name) values('130125','行唐县');
insert into sys_area(area_code,area_name) values('130126','灵寿县');
insert into sys_area(area_code,area_name) values('130127','高邑县');
insert into sys_area(area_code,area_name) values('130128','深泽县');
insert into sys_area(area_code,area_name) values('130129','赞皇县');
insert into sys_area(area_code,area_name) values('130130','无极县');
insert into sys_area(area_code,area_name) values('130131','平山县');
insert into sys_area(area_code,area_name) values('130132','元氏县');
insert into sys_area(area_code,area_name) values('130133','赵 县');
insert into sys_area(area_code,area_name) values('130181','辛集市');
insert into sys_area(area_code,area_name) values('130182','藁城市');
insert into sys_area(area_code,area_name) values('130183','晋州市');
insert into sys_area(area_code,area_name) values('130184','新乐市');
insert into sys_area(area_code,area_name) values('130185','鹿泉市');
insert into sys_area(area_code,area_name) values('130201','市辖区');
insert into sys_area(area_code,area_name) values('130202','路南区');
insert into sys_area(area_code,area_name) values('130203','路北区');
insert into sys_area(area_code,area_name) values('130204','古冶区');
insert into sys_area(area_code,area_name) values('130205','开平区');
insert into sys_area(area_code,area_name) values('130207','丰南区');
insert into sys_area(area_code,area_name) values('130208','丰润区');
insert into sys_area(area_code,area_name) values('130223','滦 县');
insert into sys_area(area_code,area_name) values('130224','滦南县');
insert into sys_area(area_code,area_name) values('130225','乐亭县');
insert into sys_area(area_code,area_name) values('130227','迁西县');
insert into sys_area(area_code,area_name) values('130229','玉田县');
insert into sys_area(area_code,area_name) values('130230','唐海县');
insert into sys_area(area_code,area_name) values('130281','遵化市');
insert into sys_area(area_code,area_name) values('130283','迁安市');
insert into sys_area(area_code,area_name) values('130301','市辖区');
insert into sys_area(area_code,area_name) values('130302','海港区');
insert into sys_area(area_code,area_name) values('130303','山海关区');
insert into sys_area(area_code,area_name) values('130304','北戴河区');
insert into sys_area(area_code,area_name) values('130321','青龙满族自治县');
insert into sys_area(area_code,area_name) values('130322','昌黎县');
insert into sys_area(area_code,area_name) values('130323','抚宁县');
insert into sys_area(area_code,area_name) values('130324','卢龙县');
insert into sys_area(area_code,area_name) values('130401','市辖区');
insert into sys_area(area_code,area_name) values('130402','邯山区');
insert into sys_area(area_code,area_name) values('130403','丛台区');
insert into sys_area(area_code,area_name) values('130404','复兴区');
insert into sys_area(area_code,area_name) values('130406','峰峰矿区');
insert into sys_area(area_code,area_name) values('130421','邯郸县');
insert into sys_area(area_code,area_name) values('130423','临漳县');
insert into sys_area(area_code,area_name) values('130424','成安县');
insert into sys_area(area_code,area_name) values('130425','大名县');
insert into sys_area(area_code,area_name) values('130426','涉 县');
insert into sys_area(area_code,area_name) values('130427','磁 县');
insert into sys_area(area_code,area_name) values('130428','肥乡县');
insert into sys_area(area_code,area_name) values('130429','永年县');
insert into sys_area(area_code,area_name) values('130430','邱 县');
insert into sys_area(area_code,area_name) values('130431','鸡泽县');
insert into sys_area(area_code,area_name) values('130432','广平县');
insert into sys_area(area_code,area_name) values('130433','馆陶县');
insert into sys_area(area_code,area_name) values('130434','魏 县');
insert into sys_area(area_code,area_name) values('130435','曲周县');
insert into sys_area(area_code,area_name) values('130481','武安市');
inser
- 1
- 2
前往页