SQL笔记：视图篇

1、视图的基本操作

（1）创建视图

--根据teachers表创建一个视图，命名为v_teachers
create view v_teachers as
select * from 'teachers';

(2)查看视图内容

select * from teachers;

(3)查看当前数据库中的所有表和视图名称和它的类型

show full tables;

(4)删除某视图

drop view 视图名;

(5)显示视图的定义

show view 视图名;

exp：

show create view v_teachers;

2、视图的检查

（1）视图的本地检查

local check ;

exp：

create view v_teachers_1 as 
select * from teachers
where age < 20
with local check option ;

(2)视图的级联检查

cascaded check;

exp：

create view v_teachers_1 as 
select * from teachers
where age < 20
with cascaded check option;