表名：ZL_ExTeacher












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40是  否  
2TClsssint40   是 老师分类
3TNamenvarchar500   是 老师名称
4Postnvarchar500   是 职位
5Teachnvarchar500   是 授课
6FileUploadnvarchar2550   是 图片
7Remarknvarchar10000   是 老师信息
8CreatTimedatetime83   是 创建时间
9AddUserint40   是 添加用户

简要说明：

考试系统教师信息表

GO
CREATE TABLE [dbo].[ZL_ExTeacher](
[ID] [int] IDENTITY(1,1) NOT NULL,
[TClsss] [int] NULL,
[TName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Post] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Teach] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[FileUpload] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[Remark] [nvarchar](1000) COLLATE Chinese_PRC_CI_AS NULL,
[CreatTime] [datetime] NULL,
[AddUser] [int] NULL
) ON [PRIMARY]

GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'老师分类' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExTeacher', @level2type=N'COLUMN',@level2name=N'TClsss'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'老师名称' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExTeacher', @level2type=N'COLUMN',@level2name=N'TName'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'职位' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExTeacher', @level2type=N'COLUMN',@level2name=N'Post'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'授课' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExTeacher', @level2type=N'COLUMN',@level2name=N'Teach'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'图片' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExTeacher', @level2type=N'COLUMN',@level2name=N'FileUpload'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'老师信息' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExTeacher', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'添加用户' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExTeacher', @level2type=N'COLUMN',@level2name=N'AddUser'

SET IDENTITY_INSERT [ZL_ExTeacher] ON
INSERT [ZL_ExTeacher] ( [ID] , [TClsss] , [TName] , [Post] , [Teach] , [FileUpload] , [Remark] , [CreatTime] , [AddUser] ) VALUES ( 1 , 4 , '吴晓1' , '教授' , '职称英语' , '/UploadFiles/Teacher/200912171601120431.jpg' , '规划局很久很久' , '2010-09-18 17:24:15.000' , 1 )
INSERT [ZL_ExTeacher] ( [ID] , [TClsss] , [TName] , [Post] , [Teach] , [FileUpload] , [Remark] , [CreatTime] , [AddUser] ) VALUES ( 3 , 7 , '城东' , '教授' , '职称计算机' , '' , '法国国歌各国国歌各国国歌各国国歌各国国歌各国国歌各国国歌广告歌根据国家规划法国国歌各国国歌各国国歌各国国歌' , '2010-09-18 17:32:18.620' , 1 )
SET IDENTITY_INSERT [ZL_ExTeacher] OFF

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

detele from ZL_ExTeacher

--注意：将删除整个表

drop table ZL_ExTeacher

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

TRUNCATE table ZL_ExTeacher