[SQL]SQL server 视图操作

 --创建视图并多表查询
 CREATE VIEW view_xinbiao_名称 AS select ziduan1,ziduan2 from biao1 inner join biao2 on biao1.ID=biao2.ID 

--显示存储过程的定义文本
sp_helptext '[dbo].[view_xinbiao_名称]'

--对视图表进行加密
alter view view_xinbiao_名称 WITH ENCRYPTION 

--例如
alter view view_xinbiao_名称 WITH ENCRYPTION 
AS
select ziduan1,ziduan2 from biao1 inner join biao2 on biao1.ID=biao2.ID 

查询操作：https://blog.csdn.net/qq_19883981/article/details/105773132
修改操作：https://blog.csdn.net/qq_19883981/article/details/105237824