表名：ZL_Course












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40是是 否  
2CourseNamenvarchar5000   是 课程名称
3CoureseThrunnvarchar500   是 课程缩写
4CoureseCodenvarchar500   是 课程代码
5CoureseCreditfloat80   是 学分
6CoureseRemarknvarchar10000   是 课程简介
7Hotint40   是 是否热门:0为否,1为是
8CoureseClassint40   是 课程分类ID
9AddTimedatetime83   是 添加时间
10AddUserint40   是 添加用户

简要说明：

课程表

GO
CREATE TABLE [dbo].[ZL_Course](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CourseName] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL,
[CoureseThrun] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[CoureseCode] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[CoureseCredit] [float] NULL,
[CoureseRemark] [nvarchar](1000) COLLATE Chinese_PRC_CI_AS NULL,
[Hot] [int] NULL,
[CoureseClass] [int] NULL,
[AddTime] [datetime] NULL,
[AddUser] [int] NULL,
CONSTRAINT [PK_ZL_Course] PRIMARY KEY CLUSTERED
(
[ID] ASC
) ON [PRIMARY]
) 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_Course', @level2type=N'COLUMN',@level2name=N'CourseName'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'课程缩写' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Course', @level2type=N'COLUMN',@level2name=N'CoureseThrun'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'课程代码' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Course', @level2type=N'COLUMN',@level2name=N'CoureseCode'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'学分' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Course', @level2type=N'COLUMN',@level2name=N'CoureseCredit'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'课程简介' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Course', @level2type=N'COLUMN',@level2name=N'CoureseRemark'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'是否热门:0为否,1为是' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Course', @level2type=N'COLUMN',@level2name=N'Hot'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'课程分类ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Course', @level2type=N'COLUMN',@level2name=N'CoureseClass'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'添加时间' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Course', @level2type=N'COLUMN',@level2name=N'AddTime'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'添加用户' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Course', @level2type=N'COLUMN',@level2name=N'AddUser'

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

detele from ZL_Course

--注意：将删除整个表

drop table ZL_Course

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

TRUNCATE table ZL_Course