省市区县四级联动单张表msssql.sql
2019最新省市县街道4级行政区域数据,自己整合的到一张表里面,可以直接生成表格数据,表格结构为CREATE TABLE [dbo].[TB_Area]( [ID] [int] IDENTITY(1,1) NOT NULL, [CODE] [nvarchar](50) NULL, [PARENT_CODE] [nvarchar](50) NULL, [NAME] [nvarchar](50) NULL, [SHORT_NAME] [nvarchar](50) NULL, [LNG] [decimal](18, 6) NULL, [LAT] [decimal](18, 6) NULL, [SORT] [int] NULL, [LEVEL] [int] NULL, CONSTRAINT [PK_TB_Area] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_Area', @level2type=N'COLUMN',@level2name=N'ID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'区域代码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_Area', @level2type=N'COLUMN',@level2name=N'CODE' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'父级区代码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_Area', @level2type=N'COLUMN',@level2name=N'PARENT_CODE' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_Area', @level2type=N'COLUMN',@level2name=N'NAME' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'简称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_Area', @level2type=N'COLUMN',@level2name=N'SHORT_NAME' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'经度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_Area', @level2type=N'COLUMN',@level2name=N'LNG' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'纬度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_Area', @level2type=N'COLUMN',@level2name=N'LAT' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_Area', @level2type=N'COLUMN',@level2name=N'SORT' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'层级' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_Area', @level2type=N'COLUMN',@level2name=N'LEVEL' GO USE [master] GO ALTER DATABASE [AREA] SET READ_WRITE GO
- 粉丝: 0
- 资源: 8
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助