关于视图

1.创建视图

create view [view_name] as select [字段名] from [table_name]

例如 create view view_user as select id,username from t_user


跨数据库建立视图

create view [view_name] as select [字段名]  from  [database_name].dbo.[table_name]  

2.修改视图

alter view [view_name] as select [字段名] from [table_name]

3.删除视图

drop view [view_name]