表名：ZL_Exam_Type












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1t_idint40是是 否 类型ID
2t_namenvarchar500   否 题型名称
3t_typeint40   是 类型：单选,多选,操作,判断，填空，语音,问答,组合
4t_remarknvarchar5000   是 说明
5t_createtimedatetime83   是 创建时间
6t_creatuserint40   是 创建用户

简要说明：

考试分类表

GO
CREATE TABLE [dbo].[ZL_Exam_Type](
[t_id] [int] IDENTITY(1,1) NOT NULL,
[t_name] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[t_type] [int] NULL,
[t_remark] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL,
[t_createtime] [datetime] NULL,
[t_creatuser] [int] NULL,
CONSTRAINT [PK_ZL_Exam_Type] PRIMARY KEY CLUSTERED
(
[t_id] ASC
) ON [PRIMARY]
) ON [PRIMARY]

GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'类型ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Exam_Type', @level2type=N'COLUMN',@level2name=N't_id'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'题型名称' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Exam_Type', @level2type=N'COLUMN',@level2name=N't_name'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'类型：单选,多选,操作,判断，填空，语音,问答,组合' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Exam_Type', @level2type=N'COLUMN',@level2name=N't_type'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'说明' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Exam_Type', @level2type=N'COLUMN',@level2name=N't_remark'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Exam_Type', @level2type=N'COLUMN',@level2name=N't_createtime'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Exam_Type', @level2type=N'COLUMN',@level2name=N't_creatuser'





GO
SET IDENTITY_INSERT [ZL_Exam_Type] ON
INSERT [ZL_Exam_Type] ([t_id],[t_name],[t_type],[t_remark],[t_createtime],[t_creatuser]) VALUES ( 1,'单选题',1,'sel','2010/09/24 14:03:39',1)
INSERT [ZL_Exam_Type] ([t_id],[t_name],[t_type],[t_remark],[t_createtime],[t_creatuser]) VALUES ( 2,'多选题',2,'sfds','2010/09/25 10:08:28',1)
INSERT [ZL_Exam_Type] ([t_id],[t_name],[t_type],[t_remark],[t_createtime],[t_creatuser]) VALUES ( 3,'主观题',5,'sdfs','2010/09/27 14:35:23',1)
INSERT [ZL_Exam_Type] ([t_id],[t_name],[t_type],[t_remark],[t_createtime],[t_creatuser]) VALUES ( 4,'判断题',3,'sdfds','2010/09/27 14:35:43',1)
INSERT [ZL_Exam_Type] ([t_id],[t_name],[t_type],[t_remark],[t_createtime],[t_creatuser]) VALUES ( 5,'填空题',4,'sdf','2010/09/27 14:35:56',1)
SET IDENTITY_INSERT [ZL_Exam_Type] OFF

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

detele from ZL_Exam_Type

--注意：将删除整个表

drop table ZL_Exam_Type

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

TRUNCATE table ZL_Exam_Type