创建,修改,删除视图

create table Employee
(

id int primary key,
name varchar(20),
dept varchar(20),
salary int --工资 敏感字段 不能随便给人看

);

insert into Employee
values
(1,'张三','技术部',8500),
(2,'李四','市场部',7200),
(3,'王五','技术部',9000);

GO

create view v_tech_emp
as
select id,name,dept,salary
from Employee
where dept = '技术部';
GO

select * from v_tech_emp

GO

create view v_emp_public
as
--故意不写 salary 隐藏工资
select id,name,dept
from Employee;

GO

select * from v_emp_public

GO

--修改视图
alter view v_emp_public
as
select id,name
from Employee;
GO

--删除视图
drop view v_emp_public
GO