表名：ZL_Datadiccategory












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1Diccateidint40是是 否 数据字典分类ID
2Categorynamevarchar500   否 数据字典分类名
3Isusedbit10   是0是否启用

简要说明：

数据字典分类表

GO
CREATE TABLE [dbo].[ZL_Datadiccategory](
[Diccateid] [int] IDENTITY(1,1) NOT NULL,
[Categoryname] [varchar](50) NOT NULL,
[Isused] [bit] NULL CONSTRAINT [DF_ZL_DATADICCATEGORY_ISUSED]  DEFAULT (0),
CONSTRAINT [PK_ZL_DATADICCATEGORY] PRIMARY KEY CLUSTERED
([Diccateid] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

SET IDENTITY_INSERT [ZL_Datadiccategory] ON
INSERT [ZL_Datadiccategory] ( [Diccateid] , [Categoryname] , [Isused] ) VALUES ( 1 , '地区选择' , 1 )
INSERT [ZL_Datadiccategory] ( [Diccateid] , [Categoryname] , [Isused] ) VALUES ( 2 , '学历信息' , 1 )
INSERT [ZL_Datadiccategory] ( [Diccateid] , [Categoryname] , [Isused] ) VALUES ( 3 , '从事行业' , 1 )
SET IDENTITY_INSERT [ZL_Datadiccategory] OFF

--注意：将清空全表数据

detele from ZL_Datadiccategory

--注意：将删除整个表

drop table ZL_Datadiccategory

--注意：清空且复位表ID序列为初始值

TRUNCATE table ZL_Datadiccategory