sql创建了视图,但是有时我们想修改视图,看以下代码语法:create table test
(
id int identity(1,1),
test1 nvarchar(50)
)
insert into test(test1) values('a')
insert into test(test1) values('b')
insert into test(test1) values('c')
select * from test
查询结果图片:
--创建一个视图
create view view_test
as
select * from test
--查询视图
select * from view_test
以下为修改视图:--修改视图关键词alter
alter view view_test
as
select * from test where id in(2,3)
查询视图:select * from view_test
select * from view_test where id=1
此语句查询无数据,因为这个视图本来不只有id=2,3的数据
select * from view_test where id=2