创建 / 修改 / 删除视图

create table studentjfa
(

id int primary key,
name varchar(20),
age int,
address varchar(50)

);

Go

insert into studentjfa
values
(1,'张三',18,'北京'),
(2,'李四',19,'上海'),
(3,'王五',18,'广州');

go

create view v_student
as
select id,name,age
from studentjfa
where age = 18;

go

--查询视图
select * from v_student;

--删除视图
drop view v_student