创建视图
create view [viewname] as select 字段名1,字段名2,字段名3 from tablename where 条件
查看视图
select * from [viewname]
撤销视图
drop view [viewname]
create view [viewname] as select 字段名1,字段名2,字段名3 from tablename where 条件
查看视图
select * from [viewname]
撤销视图
drop view [viewname]