表名：ZL_ExamPoint












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40是  否 考点ID
2TestPointnvarchar500   是 考点名称
3TIDint40   是 上级考点
4OrderByint40   是 排序
5AddUserint40   是 管理员
6AddTimedatetime83   是 添加时间

简要说明：

在线考试问题点表

GO
CREATE TABLE [dbo].[ZL_ExamPoint](
[ID] [int] IDENTITY(1,1) NOT NULL,
[TestPoint] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[TID] [int] NULL,
[OrderBy] [int] NULL,
[AddUser] [int] NULL,
[AddTime] [datetime] NULL
) 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_ExamPoint', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'考点名称' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExamPoint', @level2type=N'COLUMN',@level2name=N'TestPoint'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'上级考点' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExamPoint', @level2type=N'COLUMN',@level2name=N'TID'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'排序' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExamPoint', @level2type=N'COLUMN',@level2name=N'OrderBy'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'管理员' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExamPoint', @level2type=N'COLUMN',@level2name=N'AddUser'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'添加时间' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExamPoint', @level2type=N'COLUMN',@level2name=N'AddTime'

SET IDENTITY_INSERT [ZL_ExamPoint] ON
INSERT [ZL_ExamPoint] ([ID],[TestPoint],[TID],[OrderBy],[AddUser],[AddTime]) VALUES ( 1,'完型填空',1,1,1,'2011/07/07 12:35:28')
INSERT [ZL_ExamPoint] ([ID],[TestPoint],[TID],[OrderBy],[AddUser],[AddTime]) VALUES ( 2,'阅读理解',0,1,1,'2011/07/07 10:39:09')
INSERT [ZL_ExamPoint] ([ID],[TestPoint],[TID],[OrderBy],[AddUser],[AddTime]) VALUES ( 3,'概括大意',0,1,1,'2011/07/07 10:39:22')
INSERT [ZL_ExamPoint] ([ID],[TestPoint],[TID],[OrderBy],[AddUser],[AddTime]) VALUES ( 4,'基础知识',0,1,1,'2011/07/07 9:46:26')
INSERT [ZL_ExamPoint] ([ID],[TestPoint],[TID],[OrderBy],[AddUser],[AddTime]) VALUES ( 6,'知识巩固',0,1,1,'2011/07/07 13:17:53')
INSERT [ZL_ExamPoint] ([ID],[TestPoint],[TID],[OrderBy],[AddUser],[AddTime]) VALUES ( 7,'单元复习',0,2,1,'2011/07/07 13:34:30')
SET IDENTITY_INSERT [ZL_ExamPoint] OFF

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

detele from ZL_ExamPoint

--注意：将删除整个表

drop table ZL_ExamPoint

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

TRUNCATE table ZL_ExamPoint