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]
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]