【SQL server数据库基础】视图的操作

1. 创建视图

-- 创建视图，查询每门课的授课老师
create view View_TeacherCourse -- view 视图关键字
(课程名称,老师姓名) -- 列
as
select CourseInfoName,TeachInfoName
from dbo.CourseInfo a join dbo.TeachCourse b join dbo.TeachInfo c
on b.TeachCourseID = c.TeachInfoID
on a.CourseInfoID = b.CourseInfoID

2. 查询视图

select * from dbo.View_TeacherCourse

3. 查看视图的定义|语法

exec sp_helptext View_TeacherCourse

4. 修改视图

alter view View_TeacherCourse 
(课程名称,老师姓名,职称) -- 列
as
select CourseInfoName,TeachInfoName,TeachInfoKnow
from dbo.CourseInfo a join dbo.TeachCourse b join dbo.TeachInfo c
on b.TeachCourseID = c.TeachInfoID
on a.CourseInfoID = b.CourseInfoID

5. 删除视图

drop view View_TeacherCourse

主文章：备考计算机三级数据库——SQL 案例