创建视图
创建视图之前先看看数据库中有没有这个视图,如果有就删除
if(exists(select *from sys.objects where name='v_stu))
drop view v_stu
create view v_stu as select id,name,age,sex from studnet
修改视图
alter view v_stu as select id,name,sex from student
查看视图
select *from v_stu
创建视图
创建视图之前先看看数据库中有没有这个视图,如果有就删除
if(exists(select *from sys.objects where name='v_stu))
drop view v_stu
create view v_stu as select id,name,age,sex from studnet
修改视图
alter view v_stu as select id,name,sex from student
查看视图
select *from v_stu